ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What does it mean to have a file name followed by .xls:1 etc.? (https://www.excelbanter.com/excel-discussion-misc-queries/60199-what-does-mean-have-file-name-followed-xls-1-etc.html)

KGAR

What does it mean to have a file name followed by .xls:1 etc.?
 
I received an Excel spreadsheet that produces two separate spreadsheets when
I open it. They have the same names except that one is .xls:1 and the other
..xls:2 and I have not been able to find what this signifies.

Ron Coderre

What does it mean to have a file name followed by .xls:1 etc.?
 
Those are multiple windows that view the same Excel file.
You create them by selecting WindowNew Window.

If you close the :2 window, the other will still be open (but the :1 will no
longer display)

Does that help?

***********
Regards,
Ron


"KGAR" wrote:

I received an Excel spreadsheet that produces two separate spreadsheets when
I open it. They have the same names except that one is .xls:1 and the other
.xls:2 and I have not been able to find what this signifies.


Matt7102

What does it mean to have a file name followed by .xls:1 etc.?
 
The last person to save the file had two windows open on the document; to
eliminate this (barring protection), close .xls:2, save file, close .xls:1.
Next file opening should be a single window document.

Matt7102

"KGAR" wrote:

I received an Excel spreadsheet that produces two separate spreadsheets when
I open it. They have the same names except that one is .xls:1 and the other
.xls:2 and I have not been able to find what this signifies.


Dave Peterson

What does it mean to have a file name followed by .xls:1 etc.?
 
I like this to close windows I don't want.

Select the window I don't want.
hit ctrl-w
save the workbook the way I like (so I don't have to do it again)

KGAR wrote:

I received an Excel spreadsheet that produces two separate spreadsheets when
I open it. They have the same names except that one is .xls:1 and the other
.xls:2 and I have not been able to find what this signifies.


--

Dave Peterson


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com