Excel for mac opens all files on desktop
Solved/Closed
Related:
- How to open excel file on mac
- Excel for MAC - - Opens all files on desktop - How-To - MacOS
- Can't delete files from desktop mac - Guide
- Mac receive bluetooth file - Guide
- How to split each excel sheet into a separate file - Guide
- Android file link desktop - Guide
4 replies
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.
kaiyasit
Aug 12, 2009 at 06:34 AM
- Posts
- 30
- Registration date
- Sunday August 9, 2009
- Status
- Member
- Last seen
- April 20, 2010
Aug 12, 2009 at 06:34 AM
Disable macro, and try to open again.
this may be help you......
this may be help you......
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.
HELP!
HELP!
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.
Hi all,
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).
Hope that's useful
(MS Office 2008 mac v12.2.3)
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).
Hope that's useful
(MS Office 2008 mac v12.2.3)
Oct 22, 2011 at 07:47 AM
Thank you for an easy and quick fix to this really annoying problem.
Oct 20, 2012 at 06:20 PM
Dec 18, 2012 at 12:08 PM
Feb 14, 2013 at 01:52 PM