[file name].xls:2...what is ":2" ???

M

Marc

It seems that my file has duplicated itself. When I open
the file in Excel 97, there is actually two (2) "files"
that open. When I click on "Window" drop down menu, I see:
[file name].xls:1
[file name].xls:2

Both files are the same but seem independant. What is
that ":1" & ":2" ??
Can someone tell me:
(1) What I did to get this?
(2) How MS Excel refers to or calls that function
(3) How do I change my spreadsheet to the original
version?
Any help will be greatly appreciated.
Marc
 
P

papou

Hello
You have opened two windows from the same workbook.
Close one Window (click on the "x" on the right top of the worksheet)
Save your workbook

HTH
Cordially
Pascal
 
H

Hari

Hi,

You have opened 2 instances of the same file. This can be done by going to
Window -> New window.

Close the one saying ":2" because if you close ":1" then you might lose the
freeze panes and zoom set in the individual worksheets.

Other than the above it has no effect.

Regards,
Hari
India
 
D

David McRitchie

Hi Marc,
If you use Window (menu), New Window
you can add a third view of the workbook. It is just a view
to get rid of them simply close them with the [x] to close the
file for each you want to get rid of. When you are down to one
the digit at the end will disappear. If you don't want to see it
repeated next time you open then save the file at this point.

Additional views are helpful for looking at two different sheets,
or a total row at the same time as other data.
 
H

Hari

Hi David,

What does "a third view of the workbook" mean. OP mentioned about :2.

Is having 2 windows interpreted as third and so on.?

Regards,
Hari
India

David McRitchie said:
Hi Marc,
If you use Window (menu), New Window
you can add a third view of the workbook. It is just a view
to get rid of them simply close them with the [x] to close the
file for each you want to get rid of. When you are down to one
the digit at the end will disappear. If you don't want to see it
repeated next time you open then save the file at this point.

Additional views are helpful for looking at two different sheets,
or a total row at the same time as other data.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

It seems that my file has duplicated itself. When I open
the file in Excel 97, there is actually two (2) "files"
that open. When I click on "Window" drop down menu, I see:
[file name].xls:1
[file name].xls:2

Both files are the same but seem independant. What is
that ":1" & ":2" ??
Can someone tell me:
(1) What I did to get this?
(2) How MS Excel refers to or calls that function
(3) How do I change my spreadsheet to the original
version?
Any help will be greatly appreciated.
Marc
Click to expand...
Click to expand...
 
D

David McRitchie

Hi Hari,

Marc already had *two* views:
[file name].xls:1
[file name].xls:2

since he probably did not know what they were or how he got it,
told him how to add another one (a *third* view).
Window (menu), New Window, to get a
[file name].xls:3

Then I told him what they were for, how useful they can be.

Then I told him how to eliminate them.

Finally so he would see only one view next time he opens, he
would have to save the file; otherwise, it would open with whatever
views he had last time the workbook was saved.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hari said:
Hi David,

What does "a third view of the workbook" mean. OP mentioned about :2.

Is having 2 windows interpreted as third and so on.?

Regards,
Hari
India

David McRitchie said:
Hi Marc,
If you use Window (menu), New Window
you can add a third view of the workbook. It is just a view
to get rid of them simply close them with the [x] to close the
file for each you want to get rid of. When you are down to one
the digit at the end will disappear. If you don't want to see it
repeated next time you open then save the file at this point.

Additional views are helpful for looking at two different sheets,
or a total row at the same time as other data.
Click to expand...
Click to expand...
 
H

Hari

Hi David,

Thnx.
Got ur way of explanation.

Regards,
Hari
India

David McRitchie said:
Hi Hari,

Marc already had *two* views:
[file name].xls:1
[file name].xls:2

since he probably did not know what they were or how he got it,
told him how to add another one (a *third* view).
Window (menu), New Window, to get a
[file name].xls:3

Then I told him what they were for, how useful they can be.

Then I told him how to eliminate them.

Finally so he would see only one view next time he opens, he
would have to save the file; otherwise, it would open with whatever
views he had last time the workbook was saved.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi David,

What does "a third view of the workbook" mean. OP mentioned about :2.

Is having 2 windows interpreted as third and so on.?

Regards,
Hari
India

David McRitchie said:
Hi Marc,
If you use Window (menu), New Window
you can add a third view of the workbook. It is just a view
to get rid of them simply close them with the [x] to close the
file for each you want to get rid of. When you are down to one
the digit at the end will disappear. If you don't want to see it
repeated next time you open then save the file at this point.

Additional views are helpful for looking at two different sheets,
or a total row at the same time as other data.
Click to expand...
Click to expand...
Click to expand...
 
D

Dave Peterson

I like to select the window I don't want and then hit ctrl-w to close it.

Then save the workbook--so it's ok the next time I open it.
It seems that my file has duplicated itself. When I open
the file in Excel 97, there is actually two (2) "files"
that open. When I click on "Window" drop down menu, I see:
[file name].xls:1
[file name].xls:2

Both files are the same but seem independant. What is
that ":1" & ":2" ??
Can someone tell me:
(1) What I did to get this?
(2) How MS Excel refers to or calls that function
(3) How do I change my spreadsheet to the original
version?
Any help will be greatly appreciated.
Marc
Click to expand...
 
Top