Excel for MAC - - Opens all files on desktop

June 2017



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


Published by aakai1056. Latest update on December 10, 2009 at 03:43 PM by aakai1056.
This document, titled "Excel for MAC - - Opens all files on desktop," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).