Spreadsheet name ending with :1

  • Thread starter Thread starter gacollege
  • Start date Start date
G

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
 
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 **
 
Not a templete.....or I think not. How would I have mistakenly made it
one? And how can I change it back?
 
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 **
 
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.
 
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








Ken said:
*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.
Click to expand...
 
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

gacollege > said:
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
Click to expand...
 
Back
Top