View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default XL97 changes filenames upon open


Saved from a previous post:
===========================

Are you opening a template file (*.xlt) or a normal workbook file (*.xls)?

If you're opening a template file, then this is the way excel works--so you
don't overwrite that template.

If you're opening an excel file, then excel/windows is confused.

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)


CLR wrote:

Hi All...........

Just started today...........when I open any .xls file, either C drive or
network, by doubleclicking in WinExplorer, the name of the file is changed
by XL adding a 1 to the end of the filename.............then won't "SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had this
one before?

Vaya con Dios,
Chuck, CABGx3


--

Dave Peterson