Spreadsheet name ending with :1

[gacollege]

Got a quick question, I went to save a spreadsheet and for some reaso
it added a :1 at the end of the spreadsheet name. No matter what I d
I cannot get it off.......what gives?

Thanks,
Richar

 

[Paul B]

Is the sheet a template? if so it will add a 1 to the end of the name
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[gacollege]

Not a templete.....or I think not. How would I have mistakenly made it
one? And how can I change it back?

 

[Paul B]

Is it a .xls, workbook or a .xlt, template, file?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[gacollege]

.xls file is what it says under the properties

 

[Ken Wright]

If you hit Window, do you by any chance see File:1 and File:2 in there at the
bottom. If so then just click on File:2, then close it using the X button for
the window, which is BELOW the main X button that will close Excel. Now save
the remaining file. This happnes if you do Window / New Window and then save
the file. It allows you to have two copies of your file open which you can then
tile using Window / Arrange and compare two sheets in the same book.

 

[gacollege]

No there is only the file listed with "name:1" ....but if you go t
'open file' it only shows "name".

But by your explaination I think I see what caused this.... what I di
was hit new window a while back.....closed the original and then kep
the file with :1. So it looks like now I cannot get ride of this file


In addition if I go to open file..... if will open but not withou
first looking in Windows to find it. Strange.

Any ideas to get rid of :1?

Richard

*If you hit Window, do you by any chance see File:1 and File:2 i
there at the
bottom. If so then just click on File:2, then close it using the
button for
the window, which is BELOW the main X button that will close Excel.
Now save
the remaining file. This happnes if you do Window / New Window an
then save
the file. It allows you to have two copies of your file open whic
you can then
tile using Window / Arrange and compare two sheets in the same book.

 

[Chip Pearson]

Go to the Window menu and choose Unhide to ensure that you don't
have the second window hidden.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

No there is only the file listed with "name:1" ....but if you go to
'open file' it only shows "name".

But by your explaination I think I see what caused this.... what I did
was hit new window a while back.....closed the original and then kept
the file with :1. So it looks like now I cannot get ride of this file.


In addition if I go to open file..... if will open but not without
first looking in Windows to find it. Strange.

Any ideas to get rid of :1?

Richard

 

[gacollege]

THAT GOT IT!!!! THANKS FOR ALL YOUR HELP!!!!!!

Richard