Excel for mac opens all files on desktop
[Solved/Closed]
Related:
- How to prevent files from opening automatically in excel 2016 mac
- Excel for mac opens multiple files - Best answers
- Excel opens multiple files when starting mac - Best answers
- How to get data from one excel file to another automatically - How-To - Excel
- How to stop batch file from closing automatically - How-To - Operating Systems
- How do i get chrome to just open a file and not automatically save it - How-To - Google Chrome
- Exe file not running in windows server 2016 - How-To - Windows
- How to delete files in usb that cannot be deleted mac - Forum - MacOS
4 replies
tapzee
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
- Posts
- 30
- Registration date
- Sunday August 9, 2009
- Status
- Member
- Last seen
- April 20, 2010
Disable macro, and try to open again.
this may be help you......
this may be help you......
bronx
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!
emee
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.
wuontherocks
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)
Thank you for an easy and quick fix to this really annoying problem.