XL 2000 Changes File Name for Save

  • Thread starter Thread starter Sam Allgood
  • Start date Start date
S

Sam Allgood

When I save my Excel spreadsheet, Excel adds a 1 to the
file name (file.xls becomes file1.xls). When I remove the 1
and save it, it responds with the overwrite message? It
just started doing this several weeks ago and I can't
figure out why. Anyone know what's going on?
 
Are you sure that the additional 1 is added when you're doing the save?

Could it have been added when you were opening the workbook? If you try it
again, do you see: File1 (instead of File.xls) in the title bar?

If yes, then it sounds like you've opened the file via a double click in windows
explorer. And windows told excel to use this file as a template for a new
workbook.

You can check by rightclicking on the file in windows explorer--you'll see the
context popup menu and one of the items will be bold. If it's Open, then I'm
all wet. If it's New, then we found the problem.

And if we did find the problem, you can try to reset the default behavior for
double clicking by:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

=====
I don't have a guess if it's not this problem.
 
Thanks, Dave, that's helpful. Though your analysis was
correct (it is defaulting to New), the solution did not
work. I even tried rebooting after executing the 2
commands, but the default is still set to New. With the
second command, it indicated it was installing Execl SR-1
Profession, so I'm wondering if it might be something
that SR-1 did.
 
I use win98 and I can change the default behavior manually by:

Under Windows Explorer
View|Folder Options|File Types Tab
Scroll down to Microsoft Excel Worksheet (extension XLS)
Click on Edit
Make sure that Actions is set to Open (not New)

(I was hoping /unregserver and /regserver would fix this. (I think it's easier
and safer.))
 
Back
Top