I am trying to find out why the number 1 is added to the file name after it
is opened in Excel? I am using Excel from Office 97. It only happens when I
open the file from Windows Explorer or from a shortcut on my desktop.

It sounds like windows is using New as the default action when you doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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.

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)



JohnS wrote:

I am trying to find out why the number 1 is added to the file name after it
is opened in Excel? I am using Excel from Office 97. It only happens when I
open the file from Windows Explorer or from a shortcut on my desktop.

--

Dave Peterson

Dave,

Thanks. That fixed the problem.

"Dave Peterson" wrote:

It sounds like windows is using New as the default action when you doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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.

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)



JohnS wrote:

I am trying to find out why the number 1 is added to the file name after it
is opened in Excel? I am using Excel from Office 97. It only happens when I
open the file from Windows Explorer or from a shortcut on my desktop.

--

Dave Peterson