Why do my Excel files open up automatically, when I open excel?

0 votes
asked May 18 in MS Excel Issues by Tammy (270 points)

Can anyone help me, every time when I open Excel, all my files open up automatically? I close the application and reboot my PC but this doesn’t solve the issue. Please tell me how I get rid of this irritating issue. Using excel 2010.

1 Answer

0 votes
answered May 18 by Tammy (270 points)
 
Best answer

When the Excel is started then the entire files located in the XLStart folder are automatically opened. This generally occurs apart from the type of file. Moreover, if you have specified an alternative startup folder for excel every file in the folder also open automatically. 

 So, to stop files automatically opening in Excel 2010, remove a folder name in the Excel options:

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

Now check the XLSTARTUP Folders

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

C:\Program Files\Microsoft Office\Office14\XLSTART (for Excel 2010)

C:\Documents and Settings\User name\Application Data\Microsoft\Excel\XLSTART

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

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.
...