Always save as

[Elie]

This has just started happening in the past week. When I open an excel file,
any excel file, it places a 1 at the end of the name and then when I go to
save it, it prompts me with the saves as window. I am not sure what is going
on, anybody have any ideas. Office 2007 on XP SP3.

Thanks

 

[Dave Peterson]

(saved from a previous post)

This is exactly the way excel treats template (*.xlt) files.

If you're saving as a template file, then don't do that anymore. Save as a
normal workbook (*.xls).

But if you're saving as a normal workbook...

Are you opening .xls files by doubleclicking them in windows explorer?

And do the workbooks that are opened look like:
mybook1
mybook2
....
mybookN
(no extension at all???)

If all that's true, then it sounds like windows thinks that the file should be
treated as a Template. If you rightclick on that file in windows explorer, do
you see Open in bold or New in bold?

If you see New in bold, then the first thing I'd try is to reregister excel.

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

Then test it out.

If that doesn't work...

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)

 

[Elie]

Thanks Dave,

I was using workbooks and not templates but I think the reregistering of
excel helped.

Elie

 

[Dave Peterson]

I figured that windows/excel got mixed up and started treating your workbooks as
templates.

If reregistering didn't fix the problem, then the manual technique should fix
it.