Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

XL 2000 Changes File Name for Save

2 views
Skip to first unread message

Sam Allgood

unread,
Oct 14, 2003, 9:40:16 AM10/14/03
to
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?

Dave Peterson

unread,
Oct 14, 2003, 6:38:57 PM10/14/03
to
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.

--

Dave Peterson
ec3...@msn.com

anon...@discussions.microsoft.com

unread,
Oct 15, 2003, 1:22:00 PM10/15/03
to
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.

Sam Allgood

unread,
Oct 15, 2003, 2:30:55 PM10/15/03
to
Also downloaded and installed SR-3. Still no change
>.
>

Dave Peterson

unread,
Oct 15, 2003, 6:00:36 PM10/15/03
to
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.))

--

Dave Peterson
ec3...@msn.com

0 new messages