Whenever I open any Excel file, Excel opens every file on my desktop as well (excel or not). I have to wait until the whole bunch load up, then close them all. Any thots?
Here's an even simpler way to do it. I went into Documents and created a Folder (named "excel empty") and then went into Excel>Preferences>General and set the Open All Files In ... to this new empty folder. Seems to do the trick, as Excel now just opens to an empty worksheet. Can't image why Microsoft didn't just make this the default in the first place.
Was this answer helpful?Thanks for your feedback.
Don't forget to take a few seconds to say thanks: Thanks for your feedback.
We're sorry. Our aim is to give you the best possible answer.
The same thing happens to my mac! Everytime I open excel, it tries to open every file in my documents folder! Even files of different incompatible types. I can't get into "preferences for Excel" because of all the error messages. I've looked for Macros on the desktop and it does not find any.
I called Mac support and they said its a Microsoft problem. I have Microsoft Office for Mac. Called Microsoft support and they walked me through a fix. They were great. Sorry I can't remember the fix. It involved a number of steps. But they didn't charge me anything for the phone consult.
This fix is probably too late for you guys, but may be useful for the next person. Same thing happened to me; excel was trying to open a few Gb of zip files!
If excel never manages to startup properly:
- force quit
- move all the files from the directory where excel is opening files to a temporary folder (delete everything from old directory making sure you don't loose any files!)
- open excel; it should be speedy now.
- go to excel>preferences>general, and delete the path in: 'At startup, open all files in:'
- move all your files from the temporary folder to their original folder (& overwrite the newly created 'Microsoft user data' folder)
I'm guessing this happened after I changed the 'preferred file location', but I can not remember whether the change in '...open all files in:' was an error on my part (very stupid one).
That was useful. Thank you. Could you say more about the User Data file deletion:
a. Location? I found one but it has loads in am am reluctant to delete it without knowing:-
b. What does it do?
c. Was this really created as part of the process you describe?
Thank you for an easy and quick fix to this really annoying problem.