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.