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

[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

 

[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

 

[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

 

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

 

[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

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.

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

 

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

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

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.

 

[Hari]

Hi David,

Thnx.
Got ur way of explanation.

Regards,
Hari
India

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.

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

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.

 

[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