Excel Help - Everytime I open an existing worksheet it opens as a new file?

Question

I must have changes some of the setting on my excel defaults, because everytime I open an existing excel file it opens it as a new file and adds a 1 to the end of the file name... Is there anyway I can fix this? Thanks

Answer 1

A number of things can cause this to happen.



1. If this happens for every excel file you opened, it could be caused by a macro in personals.xls. You need to delete this file if it exists.

Go to directory: c:\users\(your username)\appdata\Roaming\Microsoft\Excel\XLSTART. Delete the personals.xls file.



2. If only certain files are affected, it could be caused by a macro within the file. Press ALT+F11 when you open the excel file. Click on every "module" you see in the Visual Basic Editor, seek out any macro that seems to be opening new files. Delete the macro.



Also, click on the "ThisWorkBook" item check for any macro that are automatically executed. They begin with "Private Sub Workbook_Open()". Delete that macro too.



3. If all else fails, get a friend who is good with Excel macros to look at it for you.

Answer 2

Hello Mr. R



Start your Excel in Safe Mode by pressing CTRL while clicking on the Excel icon to open it.



Excel will send you a message that you are attempting to start in Safe Mode, click continue.



See if the same issue repeats in Safe Mode.



Close Excel. Restart Exscel normally.



Hope this helps to solve your issue.



Also check a possible solution at Microsoft Office Articles Magazine :



About the XLStart Folder in Microsoft Excel

First, there are really two Excel Startup folders.



One is created by default when you install the application. Its name is XLStart.



The other is created if you go to ToolsàOptions, General tab, and enter a location in the At startup.





http://www.officearticles.com/excel/about_the_xlstart_folder_in_microsoft_excel.htm



Hope this helps to find a solution to your issue with Excel. Take care.

Answer 3

"...adds a 1 to the end of the file name..."



Are you double clicking on a Template file?

Template files will end in .xlt (for Office 2003 and earlier.)



If you double click a .xlt file, it will open as a New file. (filename1 / filename2 / filename3 / etc.)

This is how Templates are designed.



If you want that to stop, save your Template (.xlt) as an Excel file (.xls).

Answer 4

kill every excel.exe process running in memory (in task manager)



then find on your computer every *.xlb file and then delete



finally run the following : excel /safemode



it's done