ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Curiosity: Excel opens two copies of same file (https://www.excelbanter.com/excel-discussion-misc-queries/156273-curiosity-excel-opens-two-copies-same-file.html)

DBM[_2_]

Curiosity: Excel opens two copies of same file
 
I have an excel file (example.xls) that when I open it, opens two copies at
the same time, named
example.xls:1 & example.xls:2

If I close example.xls:2, it removes the ':1' from the other file name.

Any idea how this happened? I've already copied the data to a new file and
no longer have this issue, I'm more just curious at this point.
Couldn't find any documentation through help or the knowledge base.

Thanks,
Darren

Dave Peterson

Curiosity: Excel opens two copies of same file
 
You're actually seeing two windows into the same file--not two copies of the
same file.

It's a nice feature if you want to see different worksheets (or different areas
of the same worksheet) at the same time.

You can use:
window|new window
followed by
window|arrange

to see multiple windows at the same time.

To close any window, you can select the one you want to close and hit ctrl-w.

Remember to save the workbook's windows in the state you like--or you may see
those :1 and :2 next time you open the workbook.

DBM wrote:

I have an excel file (example.xls) that when I open it, opens two copies at
the same time, named
example.xls:1 & example.xls:2

If I close example.xls:2, it removes the ':1' from the other file name.

Any idea how this happened? I've already copied the data to a new file and
no longer have this issue, I'm more just curious at this point.
Couldn't find any documentation through help or the knowledge base.

Thanks,
Darren


--

Dave Peterson

DBM[_2_]

Curiosity: Excel opens two copies of same file
 
Wow that is new to me thanks for the answer !!

"Dave Peterson" wrote:

You're actually seeing two windows into the same file--not two copies of the
same file.

It's a nice feature if you want to see different worksheets (or different areas
of the same worksheet) at the same time.

You can use:
window|new window
followed by
window|arrange

to see multiple windows at the same time.

To close any window, you can select the one you want to close and hit ctrl-w.

Remember to save the workbook's windows in the state you like--or you may see
those :1 and :2 next time you open the workbook.

DBM wrote:

I have an excel file (example.xls) that when I open it, opens two copies at
the same time, named
example.xls:1 & example.xls:2

If I close example.xls:2, it removes the ':1' from the other file name.

Any idea how this happened? I've already copied the data to a new file and
no longer have this issue, I'm more just curious at this point.
Couldn't find any documentation through help or the knowledge base.

Thanks,
Darren


--

Dave Peterson



All times are GMT +1. The time now is 01:01 PM.

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