ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   opening an excel file opens a duplicate file of the same file (https://www.excelbanter.com/excel-discussion-misc-queries/59205-opening-excel-file-opens-duplicate-file-same-file.html)

skm

opening an excel file opens a duplicate file of the same file
 
i have an excel file that when i open it it opens another duplicate file of
the same name with a (2) at the end of it.. if i edit one it updates the
second.. how can i tell it to not open another duplicate file?

Dave Peterson

opening an excel file opens a duplicate file of the same file
 
It's actually opening a second window into the single workbook.

Select the window you don't want to see and hit ctrl-w.

Then save the workbook (or you'll be doing it again when you reopen the
workbook).

skm wrote:

i have an excel file that when i open it it opens another duplicate file of
the same name with a (2) at the end of it.. if i edit one it updates the
second.. how can i tell it to not open another duplicate file?


--

Dave Peterson


All times are GMT +1. The time now is 08:09 AM.

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