ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2 excel workbooks open up from 1 file; named :1 and :2 - why? (https://www.excelbanter.com/excel-discussion-misc-queries/258750-2-excel-workbooks-open-up-1-file%3B-named-1-2-why.html)

pkn

2 excel workbooks open up from 1 file; named :1 and :2 - why?
 
We have a workbook with multiple worksheets. Many users view and add data.
Now when we open the workbook, there are two excel files attached. First
file called filename:1 and second file called filename:2. How do we "undo"
this? Just want one workbook.

Thanks.

Luke M[_4_]

2 excel workbooks open up from 1 file; named :1 and :2 - why?
 
This was created by going to Window, new window. To get rid of it, close one
of the workbooks (not all of Excel, just the one workbook) and save.

As an fyi, this view is handy when you want to compare different sheets in
the same workbook, either by Alt-tabbing back and forth, or using the
Window-arrange feature.

--
Best Regards,

Luke M
"pkn" wrote in message
...
We have a workbook with multiple worksheets. Many users view and add data.
Now when we open the workbook, there are two excel files attached. First
file called filename:1 and second file called filename:2. How do we
"undo"
this? Just want one workbook.

Thanks.





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

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