
The file opens but an error message is displayed that says a file with ▲ When I click on an Excel file to open it, X buttons in the upper right corner of the screen (don't click the OR, you can close the extra window by clicking the lower of the two Select the window that you want to close, and press Ctrl + w This sounds like you just have two windows open that are displaying If I close one of the copies, both close. An Excel file began opening two copies of Some of my Excel files have become "read-only".Ĭlear out c:\windows\temp directory on the machine that houses theįiles, then reboot ▲.
No Errors? Select the next project listed, repeat 6. On the left side there should be the project explorer. Try (in Excel) Windows, Unhide and write down which files are. Not an add-in? It will be a hidden workbook then. Scanner software typically place itself there, sometimes with code xla file in the startup directory (see previous tip).
Got the error? Uncheck the one you last checked.
If no error, check the next one and repeat from step 4. Q: When I start Excel, why is there an errorĪ: An add-in with a programming error is causing problems. Remove Unwanted FilesĪfter you locate the files, in Windows Explorer, go to those folders, and move or delete the unwantedįiles, to prevent them from opening automatically when Excel starts. In the Search box, tpe "XLSTART", and press Enter. To find the folder on your computer, open Windows Explorer, and go to the C drive. For example, it might be in this path:Ĭ:\Users\YOUR NAME\AppData\Roaming\Microsoft\Excel\XLSTART The location of this folder depends on which Office version is installed. Might have been accidentally saved to one of the XLSTART folders. If there was nothing listed in the Startup box, the unwanted files Click OK, to close the Options dialog box.
In the box for 'At startup, open all files in', you might seeįrom that box (or go to that folder and remove the unwanted files). Click the Advanced category, and scroll down to the General section. Q: When I start Excel, why do files open upĪ: To stop files automatically opening, youĬan remove a folder name in the Excel options: Start Excel, Open and Close Files Files openĪutomatically Prevent files from opening automatically in Excel For Macintosh computers, see - Excel for Mac Resources 1.