View Single Post
  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

I think reregistering excel is quicker and safer and easier to try -- so I'd use
that first.

And going through the control panel or going through windows explorer seem
pretty much equivalent to me.



Gary wrote:

I think I found a way to solve problem. Went to Control Panel/Folder
Options/File Types and then selected XLS. I clicked on Advanced and
highlighted "Open" then I clicked on "Set Default." This seems to have fixed
the problem.

"Dave Peterson" wrote:

Try opening one of your files (and do you open them by double clicking on them
in windows explorer???)

Put this in an empty cell:
=cell("filename",a1)

What do you get back?

If the cell returns the name of the file (including the path), then ignore the
rest of this message...

But if the cell looks empty, then excel is seeing your .xls file as a template.

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

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)


Gary wrote:

I checked the file extension; it is .xls not .xlt for template. Seems to do
this for many of my existing XL files.

"Anne Troy" wrote:

Sounds like you've got a template there, Gary. Either that or there's a
macro in the file that's saving it this way.
************
Anne Troy
www.OfficeArticles.com

"Gary" wrote in message
...
When I change an existing XL file and then try to save it, XL wants to
save
it as the original file name with a 1 appended. Previously XL did not do
this: it saved it with the same name and in the same folder where the
original file was. Now it wants to save this file with the new name in My
Documents.




--

Dave Peterson


--

Dave Peterson