Excel adds "1" to the filename

[Russell Pennington]

I have a computer with a new copy of Office 2002. Any
time I open a file with Excel, it adds a number 1 to the
end of the filename. Does anyone know what causes this and
how I can fix it?

 

[Ken Wright]

If you hit Window do you also see the same file with a 2 at the end. If so then
select the one with a 2, use the X at the top right of the File window to close
it and then save the remaining file (The 1 should have disappeared now). This
happen sif you hit Window / New Window and then save your file. You get a
second view of it, but having saved it like that you will always see it like
that until you change it.

 

[Peo Sjoblom]

Is the file saved as template *.xlt? If it is it will open a regular file
*.xls and put 1 at the end of the name before
the file extension. Do a save as, save as *.xls and delete the 1, next time
you open this (xls file) it should open
normally

 

[Robert Rosenberg]

Does this happen when you use Excel's File-->Open command?

Are you opening a template (XLT) file from a Windows folder like Explorer or
My Computer? If so this is expected behavior as Excel is opening a copy of
the file/template.

If this only happens when you open any Excel file from a Windows folder you
may need to update the XLS File type:

1. From any Windows folder, choose Tools-->Folder Options
2. Click the File Types tab
3. Scroll down the list and select the "Microsoft Excel Worksheet" listing
4. Click the Edit button
5. The bolded action should be "Open". It may be "New", which causes a copy
of the file to open (with the number 1 next to it)
6. If necessary, click "Open" and then click the Set Default button
7. Click OK twice