File Save/Save As Issue

[Josh O.]

When I open any .xls spreadsheet, the file opens but adds a "1" to the file
name in the title bar. Then if I "Save" it pops up the Save As dialog box.

Any ideas why? The files were working fine yesterday.

OS: Windows XP Pro
Excel: 2003

 

[Dave Peterson]

Are you doubleclicking on a .xls or a .xlt file?

If it's a .xlt file (a template), then this is the behavior you want. The
purpose of a template is so you can create a new workbook based on that
template.

If it's a .xls file...

The first thing that I'd try is to reregister excel to set it back to factory
defaults.

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)

If the default action was set to New (bolded indicates default), then that could
have been your problem.

 

[Josh O.]

The default action was set to New. All fixed. The user was playing with the
default icons, guessing this got changed in the process.

Thanks Dave.

 

[Dave Peterson]

Darn users! <vbg>

The default action was set to New. All fixed. The user was playing with the
default icons, guessing this got changed in the process.

Thanks Dave.