Excel adds 1 to the title of my document

[Wayne]

Why is it that when I open up a document up in Excel it adds a 1 after the title? Then when I
go to save it, it doesn't want to save to the document that I want.

 

[RWN]

Not too sure what you mean.
Are you talking about a new workbook? If that's the case then XL adds a
sequence # to the name to keep it unique.
The same happens when you "open" a named template by using "File->New"
to open the workbook. What you're doing is creating a workbook based on
a template so XL, again, assigns a unique # to the file. Try "opening"
the same template again and you'll note that it will increment the
sequence #.
When you "save As", are you saving as an "XLS" or "XLT" (template)?
Check the "Save as Type" and make sure it is set to "Microsoft Excel
Workbook (*.xls)".

 

[wiseman]

Wayne,
This usually indicates you have 2 versions open of the same file, one may be
hidden. Close the file with the [1] at the end of the name. Window,
unhide and see if there is another version there to unhide. You should be
able to change this and save it to its orginal name.
You might look in Tools, Option, General and see if there is a path in
'Alternate startup file location' as I think that excel will load all the
files from this location when it starts up. If your file was there it would
load every time, and if somehow it was hidden in one session it would always
open as a hidden file. You may want to clear 'Alternate startup file
location'
Hope that helps,
Barbara


Why is it that when I open up a document up in Excel it adds a 1 after the
title? Then when I
go to save it, it doesn't want to save to the document that I want.

 

[Dave Peterson]

Just to add to the confusion <bg>.

If your filename in the title looks like book1.xls:1 or book1.xls:2, then you
don't actually have two versions of the workbook open. You have at least two
windows of the workbook available.

This is very useful if you want to see different parts of the workbook at the
same time (different worksheets or even different parts of the same worksheet).

You can close one of the windows by clicking on it and hitting ctrl-F4 (or even
ctrl-W).

====
On the other hand, if your filename looks like:

book1 (no .xls and no .xls:1 and no .xls:2), then your workbook is being opened
as a template. You're just creating a new workbook based on the existing
workbook. (Sometimes very useful in its own right--but not what you want now.)

This kind of thing can happen when you double click on the file in windows
explorer.



From an earlier post that may help:

It sounds like the default behavior when you double click on a .xls file is set
to NEW, not OPEN.

Try a test to verify:

Right click on the file when you're in windows explorer.

You should get a popup with a bunch of options. I get Open and New right at the
top of the list. Open is bolded which means that Open is the default action
when I double click on the file.

If your default action is NEW, then windows will tell excel to open it like a
template. That's why you'd get the myname1 (with no extension).

If your situation matches, this is what I'd do next (the easiest, I think).

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 you could check by rightclicking again. If it looks good, try double
clicking and see if it really worked!

==========
Option 2. (A little more work.)

I use windows98, so depending on your version of windows, it might not be quite
the same--but it'll be pretty close.

Close excel
open Windows explorer (flying windows-E is a quick way)
View|Folder Options|File Types
Scroll down to Microsoft Excel Worksheet and select that
Click the Edit button
You'll see a list of Actions in a little box.
Open should be the bold one (here, too!)

If it's not, then click on Open and then click the "make default" button.

(Ok your way out.)


Now try rightclicking and then try double clicking to see if it got fixed.