Excel for MAC - - Opens all files on desktop

December 2016



Issue



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 idea?

Solution


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)

Note


Thanks to wuontherocks for this tip on the forum.

Related :

This document entitled « Excel for MAC - - Opens all files on desktop » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.