ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   duplicate workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/64881-duplicate-workbooks.html)

Duplicate workbooks

duplicate workbooks
 
I am not sure how this happened, but everytime I open a particular workbook,
it simultaneously opens another one. The workbook file that I want to open
is named PARD , but the two that open up are PARD:1 and PARD:2 .
Everything I do in one is mirrored in the other; it doesn't matter which one
I work in. There are no links present, and when I looked under the shared
workbook status, I am the only one using it. How do make this stop happening?

Govind

duplicate workbooks
 
Hi,

Its because the workbook was opened in a new window earlier (to display
a copy of the workbook in another window) and saved that way. Go to the
workbook PARD:2 and close it using the 'x' in the right hand side of the
excel window (Not the 'x' on top, which would close the entire excel).
And then save it so that it would open only as one workbook from next time.

Regards

Govind.

Duplicate workbooks wrote:
I am not sure how this happened, but everytime I open a particular workbook,
it simultaneously opens another one. The workbook file that I want to open
is named PARD , but the two that open up are PARD:1 and PARD:2 .
Everything I do in one is mirrored in the other; it doesn't matter which one
I work in. There are no links present, and when I looked under the shared
workbook status, I am the only one using it. How do make this stop happening?


Dave Peterson

duplicate workbooks
 
Click on the window you don't want anymore.

hit ctrl-w to close it

Save the workbook in that state.

Duplicate workbooks wrote:

I am not sure how this happened, but everytime I open a particular workbook,
it simultaneously opens another one. The workbook file that I want to open
is named PARD , but the two that open up are PARD:1 and PARD:2 .
Everything I do in one is mirrored in the other; it doesn't matter which one
I work in. There are no links present, and when I looked under the shared
workbook status, I am the only one using it. How do make this stop happening?


--

Dave Peterson


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

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