Unwanted Files Open Automatically When Excel Starts

Are there files that Excel opens automatically, every time you start Excel? Something changed in your computer, and Excel files are opening automatically, and you want to get rid of them. Keep reading, to see where those files might be located, and how to stop them from opening.

Also, remember to enter the Excel Giveaway at Simply Learning Excel, for a chance to win a 1-hour online Excel session (transferable) or an Excel book.

Stop files from opening automatically in Excel 2007 and Excel 2010

To stop files that automatically open in Excel 2007 and Excel 2010, you can remove a folder name in the Excel options:

• Click the Office Button, then click Excel Options (In Excel 2010, click the File tab, then click Options)
  
• Click the Advanced category, and scroll down to the General section.
  
• In the box for 'At startup, open all files in', you might see the name of a folder, and its path
  
• Clear the folder information from that box (or go to that folder and remove the unwanted files).
  
• Click OK, to close the Excel Options dialog box.

Check the XLSTARTUP Folders

If there was nothing listed in the Startup box, the unwanted files might have been accidentally saved to one of the XLSTART folders.

• C:Program FilesMicrosoft OfficeOffice12XLSTART   (for Excel 2007)
  
• C:Program FilesMicrosoft OfficeOffice14XLSTART   (for Excel 2010)
  
• C:Documents and SettingsUser nameApplication DataMicrosoftExcelXLSTART

In Windows Explorer, go to those folders, and remove the unwanted files, to prevent them from opening automatically when Excel starts.

Stop files from opening automatically in Excel 2003 and earlier versions

For earlier versions of Excel, there are instructions in the Contextures Excel FAQs: When I start Excel, why do a million files open up automatically?

More Ways to Prevent Files from Opening

You can also use a command-line switch, or the Esc key, to stop files from opening automatically. For more details on how to block files from opening automatically, see the Microsoft Knowledge Base article: How to prevent files from opening automatically in Excel.

For help with troubleshooting other problems when starting Excel, see Jan Karel Pieterse's article: Startup Problems.

Excel Tweet of the Day

Do you really trust the numbers in every report you read? This guy might work for you!

My pivot table won't pivot. Screw it. I'll make the numbers up.

For more entertaining and enlightening Excel tweets, culled from the thousands posted every day, see Excel Theatre Blog.

_______________