Excell docs save with a 1 added on.

[Kennyb]

When I save an Excell file it saves under the original name but adds a 1 to
the end. For example, if I save a file called test, the next time I save it
it comes up as test1.xls, the nest time as test11.xls. Does anyone know how
to correct this?

 

[Dave Peterson]

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...

(saved from a previous post)

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)

 

[Kennyb]

Thank you, that did the trick. It was the last option that worked. Really
appreciate the help.

 

[Kennyb]

OK
This solution has led to another problem. After making this change I get
error messages when I try to open any Excell files. The error message says
that the file could not be found and lists one word in the file name. Then
if you click OK it gives you the same message using the next word in the
name, and so on. After clicking OK for all the error messages the file opens
and works normaly from there.
This happens with new and old files. I have tried to rename the files and
get the same result. I have coppied the file into a new Excell file and
still get the same messages.
When I change the file default back to new it goes back to the original
problem.
Any ideas?
These files are being saved as .xls files. When I right click on the file
in explorer it shows New in bold.

 

[Gord Dibben]

Try the usual fix for this.

Tools>Options>General Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "excel.exe /regserver"(no quotes)>OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case Start>Run "C:\yourpath\excel.exe" /regserver(quotes required)>OK.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

And I don't think that the solution to the other problem had anything to this
problem.

Just a coincidence.