Over 1 million tech questions and answers.

PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Q: PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance for any help or suggestions.

Nick

RELEVANCY SCORE 200
Preferred Solution: PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

Read other 6 answers
RELEVANCY SCORE 161.2

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

Read other 16 answers
RELEVANCY SCORE 139.2

I had the same problem which can be found in this thread: http://forums.techguy.org/business-applications/814855-excel-2007-personal-xlsb-wont.html

I have also solved it in the same way (Renaming my personal.xlsb file to personal.xlsa)

What wasn't discovered in the last thread is *why* this works. Any ideas?

My personal file has been starting up fine for years now. And the macros have run nearly every day. What could have caused this sudden change?

Sixhobbits
 

A:Excel Personal.XLSB does not open on starting up excel

I would guess that since .xlsa is not a recognized file type - and specifically is not .xlsb (which is a recognized file type) or .xlsm (also recognized and this was tried by the person in your link), 2007 treats .xlsa as simply .xls and loads it. This is merely a guess, however, but if it is true, it raises some interesting questions about security....
 

Read other 1 answers
RELEVANCY SCORE 129.2

My personal.xlsb file does not automatically open when excel starts. I have tried to delete and recreate the file. I know that Excel is going to the XLSTART folder and trying to open the files in there, because I changed the file extension and rec'd an error message when I restarted Excel. I have tried comparing Excel options/settings with others in my group but cannot find a difference. I have even deleted my file and used a coworker's file - which works for him (it contains the same universal macro's that we use for all of our files). But when I went to open excel, it still didn't open the personal.xlsb file.
 

A:Excel 2007 personal.xlsb won't automatically open

Read other 16 answers
RELEVANCY SCORE 112.8

I understand that to hide this worksheet I need to clicke View and then hide, then Save, but excel never asks me whether or not I want to save my worksheet when I exit so I'm guessing that's why this setting won't take.

I did this successfully on a previous laptop, but it is toast due to malware. Not sure why it should be a problem on this new laptop, unless the previous user (it was issued a work, and not brand new) did something to it, alhtough regular workbooks ask if I want to save changes so why it doesn't ask when there's just personal.xlsb I don't understand.

Any suggestions?

Thanks,

Ann
 

A:Solved: Excel: personal.xlsb--can't hide it

Read other 8 answers
RELEVANCY SCORE 112.8

I am trying to create a Personal.xlsb workbook within Excel 2007. I have the workbook created, placed in the XLStart folder, and hidden.

When I double-click on the Excel icon, a new workbook does not open. I can see the menu/command options, but there is not a spreadsheet.

Can anyone tell me what I am doing wrong?
 

A:Solved: Excel 2007 - Personal.xlsb

I have the new workbook working properly with the Personal.xlsb workbook partially.

When I open a blank workbook, and when ready close the workbook the personal workbook remains open. I have to then close the personal workbook. I know there is a way to close the personal workbook at the same time as the blank workbook.

Could someone point me in the right direction?
 

Read other 2 answers
RELEVANCY SCORE 112.8

Hi,

I am working with a number of macro's used to process a pledger each month. However recently the Macros stored in the Personal.XLSB file do not appear when I go run them. I am unhiding all workbooks and even when I load the macro's from the Personal.XLSB file they do not appear.

I am using operating system Windows 7 and MS office 2010 Professional

To resolve the problem I am restarting the computer at which point the Macro's reappear however this is not the most effective solution.

Can anyone help find a better solution

Many thanks

Chris
 

A:EXCEL Personal.XLSB Macro's Dissapear

Welcome to TSG. Hope you get some help and take the opportunity to help others when you can.

I haven't experience the problem you describe but in MS Access I've found strange macro behavior in Office 2010 if the 'Trust Setttings' aren't set. You need to 'allow all macros' and trust the location of the spreadsheet.

Hope this helps.
 

Read other 1 answers
RELEVANCY SCORE 110.4

I understand in excel 2007 -- when you build a macro and save it to a personal workbook it saves the file in the xlstart menu and automatically opens behind the scenes when you open an Excel workbook---- My problem is when I build a macro and it asks if I want to save changes to the personal,xlsb file if I click on yes -- from than on, when I open Microsoft excel the standard blank sheet one does not open but the personal.xlsb which is supposed to open but behind the scene. Any suggestions... J.T.
 

A:Solved: issue with excel 2007 personal.xlsb file

I don't know 2007. But in previous versions you have to hide personal.xls, then close Excel (it'll probably prompt you to save), then re-run Excel & it should stay hidden.

HTH
 

Read other 2 answers
RELEVANCY SCORE 106.8

Hello!

I need to convert xlsx-files to xlsb-files. I've found some tools on the internet, which are able to do that, but only if all the xlsx-files are in one folder.

My folder topology looks like this:
main folder -> containing 44 folders -> each of them containing 1-3 specific folders -> where each of those specific folders contain 1 specific folder -> which contains the xlsx-files (about 10-30 files) which need to be converted into xlsb-files.

In short: there are about 1800 xlsx-files widespread amongst some folders and subfolders. And because there are so many folders and files, it would be a horror to do this manually.

The format of the folders is the same for all of them (just timestamps and numbering differs).

A:Batch processing (xlsx to xlsb) in Excel 2010

What tools have you found? I'm having trouble locating any.

Read other 9 answers
RELEVANCY SCORE 104

Excel will not open my personal.xlsb file but if i create a copy entitled "Copy of Personal.xlsb" it will be recognized. This is quite irritating.
 

A:Personal Xlsb wont open but "Copy of Personal.xlsb" will

So I assume you tried renaming the original Personal.xlsb file and creating a new one?

You should also be able to go to the Excel startup directory and manually open the file in order to save/export any existing code modules to a new workbook.

Rollin
 

Read other 3 answers
RELEVANCY SCORE 98

I need to copy only  all excel files xlsx , xls, xlsm,xlsb in my documents
path as below

C:\Users\user\Documents

to  path C:\Users\user\backupoffice    keeping the folder structure including subdirectories.

  Can this be done with robocopy I used both windows 8.1 and windows 7.

looking a code to do this

Can anyone assist

thanks

Read other answers
RELEVANCY SCORE 96.8

I am having a problem opening a .tsv file with office 2010 running windows 7 on multiple machines.

Here is the situation:
I am exporting a document from Oracle. The file is in the .tsv format. It prompts me to open or save. Of course if I try either it tells me I need to set a default program to open the file. I search for the Excel program from my Office/Office14 file. Click Ok and then when I double click on the file to open it nothing happens.
I have tried manually setting the default association and it will never open the file.
This works flawlessly on a windows xp machine running Office 2007 or before. 2010 Excel is the only problem we have had.
I have only been able to trick it into using Excel so far. When it asks me to save the document I chose a location and type .xls after the file name. When I open it there is an error message and I have to resave it, but then it works.

If it was me I wouldnt worry about this, but I have 100 users that may start having this issue and they will not want to deal with it.

Any help would be appreciated.

Thank you
 

A:Excel 2010 will not open .tsv files

Read other 15 answers
RELEVANCY SCORE 96.8

Similar to your conversation string back in 2010, I have found the same problem: when exporting a .tsv file from Oracle (having already associated it with Excel through the Default Programs section of Windows 7), my computer thinks about it, then does nothing. I was able to do this seamlessly with Excel 2007. Any updates since 2010 on this?
 

A:Excel 2010 Does not open .tsv files

Hi, welcome to the forum.
Nothing's changed, 2007 or 2010, all the same.
Did you reset your association with Excel 2010 after you installed it?
 

Read other 1 answers
RELEVANCY SCORE 96

I am having problems trying to open Excel files by double clicking them for some strange reason.

If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010 anywhere, so what I done was to create an Excel short cut on the desktop and then tried to use that as the default program but I get the following message:

C:\Users\********\Documents\*******\********\****.xlsx is not a vaild Win32 application.

(I have used the *'s instead of the proper path)

A:Can't open Excel 2010 files for some reason?

  
Quote: Originally Posted by BomberAF


I am having problems trying to open Excel files by double clicking them for some strange reason.

If I create an Excel file then save it for some bizzare reason it won't then open again by double clicking it. I have tried to go into the choose default programs but I can't find Excel 2010 anywhere, so what I done was to create an Excel short cut on the desktop and then tried to use that as the default program but I get the following message:

C:\Users\********\Documents\*******\********\****.xlsx is not a vaild Win32 application.

(I have used the *'s instead of the proper path)


Have you tried right clicking on an xlsx file, choose Open With, and browse to the excel.exe? I don't have 2010, but mine is in

C:\program files (x86)\Microsoft Office\OFFICE11\EXCEL.exe

Choose the exe and click always use the selected program...

A Guy

Read other 2 answers
RELEVANCY SCORE 95.2

I am using microsoft office 2010 and windows 7.

I have set up excel to open files from a specific folder. When I click open it only shows files such as *.xls etc.

How can I setup to open all files (*.*) ?

Thank you very much
 

A:Solved: Excel 2010 - How to set open to open ALL files

Read other 12 answers
RELEVANCY SCORE 94.8

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled

I am unable to open a password protected Excel 2010 file in Excel 2007.

When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.

Using the open option has no effect on this file whatsoever.

I would be grateful for any suggestions.

Regards

Flynne
 

A:Excel 2010 file will not open in excel 2007

Does is need to be saved in a different format. Wasn't there a change in the default around that time??
 

Read other 1 answers
RELEVANCY SCORE 92.8

Hi,
I seem to be going against the tide with my query.
By default, when I open an Excel associated file by double clicking it in explorer, my Excel 2010 opens each file in a new program window. This is really annoying as I often want to consolidate data and copying and pasting is not as easy across multiple
program instances.
I've seen lots of threads of people who want to make there Excel open files in separate instances, for example:
http://social.technet.microsoft.com/Forums/en-US/office2010/thread/749983b3-ba7e-49d3-99bf-f67d70245046
http://forums.whirlpool.net.au/archive/850718
http://blog.whitesites.com/Force-Windows-7-to-open-excel-documents-in-separate-windows__634014706378053750_blog.htm
but no one trying to make them all open in the same window.
Can anyone help, perhaps without resorting to altering the registry?
Thanks,
 
Alex

A:Need to make Excel 2010 open files in the same instance of the program (Windows 7)

In Excel 2010 go to File\Options\Advanced and under Display uncheck "Show all windows in the Taskbar".

Read other 6 answers
RELEVANCY SCORE 91.2

I think this problem may have to do with Windows 7 vs Windows XP. With Excel 2010 running under XP this does not happen.

Under Win 7 running Excel 2010, when saving a spreadsheet as a tab delimited text file (.txt). Excel 2010 appends the .txt file extension to a file that already has an existing file extension. For my work I must save excel files as xxxxxxx.upl but excel always saves the files as xxxxxxx.upl.txt. This only occurs under Win 7, not XP which is why I think it is an OS issue.

How can I fix this? I am guessing it is a registry fix, but I don't have any ideas of how to fix it. Thanks in advance for any suggestions!

If I add double quotes around the file name I want, like "xxxxxx.upl" the file will save as a tab delimited text file and Excel will then identify the file type as a UPL file.

What I want:

What I get without the "xxxx.upl" file name:

A:Stop Excel 2010 from appending .txt to file with existing extension

Yep, that option is called "Hide extensions for known file types".
Likely, on your XP system it is turned ON (checked) and on your win 7 machine is it turned OFF (unchecked).
But that would work for all known file types, not just the one specified.

Tutorial File Extensions - Hide or Show

Read other 9 answers
RELEVANCY SCORE 91.2

Hey all,

I'm having an issue with the Xerox Workcentre 7120 and Excel 2010. I simply cannot print Excel files whatsoever. It tells me that the document has been sent to the printer, yet two minutes later it tells me that the print job has failed - no reason given, it just says in the Completed Jobs tab that it was cancelled. When looking at the Completed Jobs tab on the printer itself, it tells me that it was "Completed-Error" - basically meaning that nothing happened. I'm running Windows 7 64-bit.

I've tried many fixes, including restarting the PC, restarting the printer, restarting the print spooler, reinstalling Office 2010 completely, installing another driver for the printer, running a repair on Microsoft Office 2010, reinstalling the printer completely (it's a network printer) and dancing around the PC in complete frustration whilst chanting (the last one helps a lot, strangely enough).

The weirdest thing is that it's just an issue with Excel - Word, Office and other Office programs print fine with this specific printer. Does anyone have any suggestions? I've tried printing to another printer in another part of the office, and that works perfectly fine. It's just a hassle having to go through multiple doors and parts of the office to retrieve a simple document.
 

Read other answers
RELEVANCY SCORE 90

I知 running Excel 2010 on both my work & home computers. I have around 30 macros stored in my Personal.xlsb file. Occasionally, I値l modify a macro at work and, to be able to have all my work macros available to me on my home PC, I値l attach the updated Personal.xlsb file to an email to myself at home. I then drag the file to the desktop, open it and attempt to save it in the appropriate XLSTART folder on my home PC.
At work, I知 using Office with Windows XP Professional; at home, I知 using it with Windows 7 Home edition.
The Problem: When I attempt to 壮ave the new macro file on my personal PC, or indeed if I actually modify a macro on my personal PC and attempt to save it (done via VBA), I知 prevented from doing so for some security reason and get a message that I should save it under a different name and move it to the XLSTART folder. Normally, when I do this (though it痴 sort of a pain because of 7痴 file structure), I have no problems afterward. Most recently, however, Excel launches with Personal.xlsb 繕nhidden. I致e tried several things to get it to remain hidden without success.
Any ideas what痴 wrong? How to overcome? Or for that matter, why I can't save the modified file directly to \XLSTART?
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 8191 Mb
G... Read more

A:Solved: Personal.xlsb not hidden on open/can't save

Pls use explorer to copy and paste the file, not in VBA when excel is open.
Cos when excel is open Personal.xls is in use.
Also check that XLSTART is trusted in Trusted Location.
 

Read other 2 answers
RELEVANCY SCORE 90

Hi! i need you help!.. I am unable to open or save files in the shared drive using Excel 2007 but i can open/save excel 2007 files saved in my local drive

The error message I get when i try to open is "Could not open...." followed by the path and excel name.

This is the error message i get when i try to save in the shared drive:

Microsoft office excel cannot acces the file". There are several possible reasons:

the file name or path does not exist
the file is being used by another program
the workbook you are trying to save has the same name as a currently open workbook

Please help
 

A:Unable to Open and Save Excel files in the shared drive using Excel 2007

Read other 15 answers
RELEVANCY SCORE 90

Ok this is a weird problem I ran into in the past with Word, and I'm having trouble finding information on it, because of the details involved.

What's happening is if i load up Excel and then goto file/open and load an excel document it comes up.

If I goto Start/Documents and try to load it from there Excel seems to hang, also if i Browse my computer and goto any excel file same thing happens, and of course it happens over a network share as well.

I didn't give it more then a minute or 2 to come up (We are talking small Excel files here nothing huge) On the last computer this happened on with Word, the documents would eventually come up, but it would take 5 minutes to load this way.

Anything I load withen Excel (Meaning I load excel and then goto File/Open, comes up instantly)

Windows knows how to handle the excel files and what program to load them with, I tried deleteing the (Is it called a mime?) entry in windows that tells excel how to handle the .XLS file, then held shift and Right clicked a .XLS file to re-enter it into Windows, just in case Windows wasn't opening it right but this had the same effect.
Any ideas?
Thanks
 

A:Can't open excel files by double clicking, HAS to load withen excel

Read other 9 answers
RELEVANCY SCORE 88.8

I have a similar problem as the previous posting but my problem is with Excel not Word. When trying to open any Excel file I receive the message: "There was a problem sending the command to the program." The only way I can access an Excel file is to open "All Programs," choose "Microsoft Office" folder, choose "Microsoft Office Excel 2007" icon, choose "Open" folder, and double click on desired file.

My computer is a three month old custom unit built with Windows 7 Professional. I am using Microsoft Office Home and Student 2007. There have been no problems until this week.

Thanks for any help,

Wilks
 

Read other answers
RELEVANCY SCORE 88.8

I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The interesting thing is that if I try to open the same file that I have saved within the last year (before I got 2007) then I can do it? That is, I have a cache folder of files that I go get to do calculations then save in a new job folder. The ones in the new job folder will open (also 2003), but the ones in the original cache will not? I would truly appreciate any suggestions. Thank you.

A:Can't open 2003 Excel Files in Excel 2007?

Have you attempted to set them up in 'Compatibility Mode." Not sure if this will help, just hoping it will. I have been testing the new Microsoft Office 2010 Beta 64 bit, and have yet to have this problem, and like you I have a great deal of files in 2003 (never used 2007)'

I think you can still download MS Office 2010 beta from Microsoft's download site. Good Luck.

BTW, Welcome To The Seven Forums.

Read other 9 answers
RELEVANCY SCORE 88.4

Dear Forum Members,

I recently discovered a problem with my excel application. Whenever I am browsing the web with IE or Firefox I am unable to launch any of my excel spreadsheets (.xls/,csv files) by double clicking on them in my folders. There are NO crashes or error messages. The applications just waits until you close your web browser and immediately launches once closed. I did a couple of tests and found out that:

1. Excel can be manually opened if you clicked on it's main shortcut but NOT by double clicking on any of the spreadsheets.

2. Double clicking on the spreadsheet will only work if certain websites are opened. For instance, if I were to go to MSN.com and try to double click on my worksheet it does not launch. But if I were to a) close my browser showing MSN.com it will launch OR b) from MSN.com type in another URL such as Google.com the application will immediately launch. It seems that I cannot launch my spreadsheets ONLY if certain websites are opened. I find this rather odd.

I am currently using ms excel office 2003. Any advice, help or suggestion would be deeply appreciated. Thank you in advance.
 

A:Excel cannot open while web browser opened

Open Excel before you start browsing and keep it open in the background.
 

Read other 1 answers
RELEVANCY SCORE 86

So when i open any file like a PDF or something, it's automatically opened as an excel document when i want it to be word. I've already tried setting word as a default app but it still doesn't work.
Also, i tried going to the downloaded files and pressed 'open documents like this with word from now on' but afterwards when i open that same file it still opens in excel. Can someone please help me, i have to print stuff for school but I can't because of this.
 

A:All my files are opened as excel instead of word

Well you can Print in the interim. Instead of pushing a file to an application via its File Association, you can always open the Application and then open the document and print it.

So if you try to open a PDF, DOC, DOCx, and others they are all associated to MS Excel ?

Did you Right-Click on a PDF file and choose "Open With" ---> Choose Default Program
And set it back to Adobe Reader ( or whatever PDF viewer you use ) ?

likewise...

Did you Right-Click on a DOC and DOCx files and choose "Open With" ---> Choose Default Program
And set it back to Microsoft Word ?

Additionally...
Did you go to Control Panel and use the Default Programs applet and then choose "Set your Default Program" and then choose the Program like Adobe Reader, Microsoft Word and have it "Set this program as default" ?
 

Read other 1 answers
RELEVANCY SCORE 86

In open dialog box (of an Excel 2010 file) in path File > open, there is a drop-down list for Open button. One of them is, open in browser. When Excel files can be opened in browser (Web browser, e.g., Chrome) please?

A:When Excel files can be opened in browser?

Hi Read the Link below .. It should answer your questions ...
Chrome Office Viewer: Office Files in Chrome Directly

Read other 4 answers
RELEVANCY SCORE 85.6

I am on Vista and Ecel 2007

Everytime I open an existing work in excel it opens that workbook and a new "BOOK 1" This started after I installed aspa utilities. Can someone tell me where to go to stop the extra Book from opening each time?
 

A:Solved: Excel 2007 extra book 1 when I open an existing workbook

Read other 15 answers
RELEVANCY SCORE 85.2

How can I open 2 excel files side by side in Office 2010?

A:How to open 2 excel files side by side in Office 2010?

See if this helps: Comparing Two Excel 2010 Worksheets Side by Side - For Dummies

Read other 1 answers
RELEVANCY SCORE 84

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 82

This is so very strange and I am stumped. The user had Office 2002. I uninstalled it, then installed Office 2010. When she clicks on the Excel icon (from the desktop, or from the all programs list, and even from the MS Office folder in Program files) a window pops up and it displays "the name of a document" and "file format is not valid". It is trying to open a Word document! She said this was occurring with the old Office version also. Once that window is closed Excel work fine. It's as if the Excel executable somehow became a shortcut for this Word document. She said that the document was deleted quite awhile ago.

Any help would be appreciated.
Thanks!
 

A:Excel 2010 tries to open .doc

Read other 7 answers
RELEVANCY SCORE 81.2

Couple of issues here.... help!

1) When I am in Gmail (email) and want to open a word doc or excel and try to open it by a click (internet explorer) it opens of the window that comes with the computer to "buy" or ... so I have to save on the desk top, open word or excel then open the document through the software.

2) When I am in Gmail (email) and want to open a word or excel document in (Chrome) it opens a little window which ask if I want to open, save or open/save and where to save it. If I press open another window opens and ask if I want to open it now.
How can I just click on the word or excel document from gmail or anywhere and it just open up instead of opening up the program to open within?

Thank you ahead of time!
 

Read other answers
RELEVANCY SCORE 80.4

I was reading this past thread and am having the same problem with a few machines in the office. They are all running Office 2010 on Windows 7 and I can't get the file associations correct. The newer file extenions are fine but the xls and xlsx files will not automatically open when double clicked. They WILL open if you open Excel and then go to the file, open commands. The new 2010 files will open automatically when double clicked. Files are all saved on the desktop or same folder with different results. Does anyone know of a fix to this? I have done all of the normal fixes, repaired the installation, tried manually open with and checked the always open with box, went to options, advanced, and the "Ignore other applications that use DDE" was not checked. The ONLY thing I can think of is that some of these users are using Microsoft Project 2003. But I did do a full uninstall on Office 2003, fully uninstalled Office 2010 and re-installed Office 2010 and am still not able to have the users double click to open files. Any other ideas? (Again, only happening on a few machines, other machines running Office 2010 on Windows 7 are fine)
 

Read other answers
RELEVANCY SCORE 80.4

Hi Guys,

this issue only happens to 1/2 dozen of my PC out of 150, i don't what cause it and how to solve it. had tried /regserver and adding ExtensionHardening registry to each of the PC registry to no avail. tried the open with option, redirect it to excel.exe in office14, checked the always use this program check box, yet no avail. tried repairing...no avail too.

these 1/2 dozen PC, can't open any excel extension just by 2x clicking the file. they're all using office2010. OS: XP SP3.

any lead someone?
 

A:Excel 2010 can't automatically open xls and xlsx

Read other 7 answers
RELEVANCY SCORE 80

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

Read other 14 answers
RELEVANCY SCORE 80

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help
 

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers
RELEVANCY SCORE 80

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

Read other 1 answers
RELEVANCY SCORE 80

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

Read other answers
RELEVANCY SCORE 79.6

I was searching for a way to open multiple windows in Excel every time I double clicked on an Xls or Xlsx file. I looked and found some solutions for 2007 and prior versions however I did not find any solutions for the Win7 Excel 2010 environment.

(I did find a way to do it by changing a fix for Win7 Excel 2007. Please let me know if it helps or if there is a different/better way to fix.)

Works for
Excel 2010 & Win7 (could work for 07 not tested)
------------------------------------------------------------------------
Open Registry Editor ver 6.1

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command

(Note: it doesn't matter what is listed under default)

-Change the value command and under data remove /dde (or /e) and add after existing string the following code below

/p "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" /e "%1"

(Note: /p switch will ignore the (default) open settings)

-Go to Branch:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec

-Rename ddeexec2

(compare to screen shot)
Excel 2010 Win7 Registry.jpg

Hope that helps users with Win7 Excel 2010.
-Kenton

A:Excel 2010 Win7 Open Multiple Windows

-Similar solution to above as a .reg file: Copy the following into a .txt file, then rename as a .reg file and save. Run as an administrator. You will need to replace the <Hexidecimal value> with the value specific to your install. Easy way to do that is to export your current key value.
------------------------------------------------------------------------------------

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""
"command"=hex(7):<Hexidecimal value>

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec]
@="[open(\"%1\")]"

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\application]
@="Excel"

[-HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2]
@="[open(\"%1\")]"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\application]
@="Excel"

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec2\topic]
@="system"

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /e \"%1\""
"command"=hex(7):<Hexidecimal value>

[-HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec]
@="[open(\"%1\")]"

[-HKEY_CLASSES_RO... Read more

Read other 9 answers
RELEVANCY SCORE 79.6

Every time I open an existing document in Excel it also opens a blank document (Book1) in a separate Excel session along with the document I am requesting to be opened. The same is happening with Word.

I am under Win7 Home Premium and Office 2007 Professional.

I have seen that someone had same problem, but I don't have any visio file in xlstart file.....

Do you have a fix for this problem?

Thanks, kind regards

Rey
 

A:Excel and Word 2010 open a blank page

Click on Start > Search programs and files type the following:
winword /r
(This will reset the default setting for Word 2007)

Next Click on Start > Search programs and files type the following:
excel /o
(This will reset the default setting for Excel 2007)
If the issue still persists, search "excel opening blank file" in Google and out of many search results, click on the one from answers.microsoft.com and follow the steps mentioned there.
 

Read other 1 answers
RELEVANCY SCORE 79.2

I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):

(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.

I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.

Nothing has worked. I知 barely able to get anything done! Please help, I知 dying here!
 

A:Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

Read other 16 answers
RELEVANCY SCORE 79.2

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

Read other 1 answers
RELEVANCY SCORE 79.2

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.

The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.

What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.

I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.

If you need more info please ask, I don't think I've been clear enough as English is my second language.
 

A:Excel 2010 web query is not working as it did in Excel 2007

Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.

All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.

I hope this gives you some ideas to look at
 

Read other 2 answers
RELEVANCY SCORE 79.2

Hi

Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:

https://support.office.com/en-US/ar...ions-EF163677-3195-40BA-885A-D50FA2BB6B68#bm4

https://askdrexel.drexel.edu/app/an...:-change-password-of-a-workbook-in-excel-2007

We're used to Office 2003, so this is a big jump at work for us

Thanks

eddie
 

A:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.
 

Read other 1 answers
RELEVANCY SCORE 78.8

When I double click excel files in folders, excel opens you can input data on the 'HOME' Tab at the top, but cannot use any of the quick access tool bar icons or any of the tool bar tabs 'FILE', 'INSERT', 'PAGE LAYOUT' ect. This is rather fustrating as having inputted data you then cannot save it! If you open Excel 2010 by pressing the windows key and then do FILE/OPEN>>>> you can then open the file and use excel 2010 as normal.
 

A:Opening Excel 2010 files

Welcome to TSG Frustrated-Farmer.

Not sure in Excel, but in Access in the newer version of MS Office the 'trust settings' have to be set especially if your running/making macros. And there is often an irritating 'Allow Editing' (or something like that) bar accross the top you have click even after the trust settings.
 

Read other 1 answers
RELEVANCY SCORE 78.4

Hello

I have an issue with a user. OS is windows xp and office 2010. When she gets an excel attchement, it can only open in preview mode.

I have done:
1> deleted the the contents of Temporary internet file.
2>Deselected the proetected view (all 3 oxes have been deselected.)
3> "ignore other application that use DDE" is deselcted.

Still no change.

Any help is appreciated.

Thanks
 

A:Outlook 2010 will only open excel attachement in preview mode

Try saving the attachment to a folder or to the desktop, then open from there.
To save, right-click the attachment and choose Save on the context-menu.
 

Read other 3 answers