ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2 versions of Excel file opens (https://www.excelbanter.com/excel-discussion-misc-queries/110868-2-versions-excel-file-opens.html)

ddate

2 versions of Excel file opens
 
I'm not sure if this is an error or just some setting we accidently
triggered. When we double click on a certain file there are two versions of
the same file that open simultaneously. One list the file name in the window
as a ":1" and the other a ":2".

All other files are working normally it's just this one. We did a save as
to another name but still the same issue. Please help.


Dave Peterson

2 versions of Excel file opens
 
You have opened a second window into that same workbook.

If you want to close one, just click on it and hit ctrl-w

Remember to save the workbook before you close--else you'll be doing it again.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

This can be caused by using:
Window|New window
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.

ddate wrote:

I'm not sure if this is an error or just some setting we accidently
triggered. When we double click on a certain file there are two versions of
the same file that open simultaneously. One list the file name in the window
as a ":1" and the other a ":2".

All other files are working normally it's just this one. We did a save as
to another name but still the same issue. Please help.


--

Dave Peterson


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

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