ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Duplicating Workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/39947-excel-duplicating-workbooks.html)

luke1438

Excel Duplicating Workbooks
 

Someone in my office sent an Excel file to me. When I open it two files
open one has the extension .xls:1 and the other .xls:2. They appear to
be the same file, I cannot delete either one without the other one
being deleted. Renaming and doing a save-as only compounds the problem,
I then have two more files with the :1 and :2 after the file extension.


Any helpful ideas on how to get just one file would be greatly
appreciated.

Thanks


--
luke1438
------------------------------------------------------------------------
luke1438's Profile: http://www.excelforum.com/member.php...o&userid=18407
View this thread: http://www.excelforum.com/showthread...hreadid=395065


Dave Peterson

This is actually just two (or more) windows into the same workbook.

Just select one of the windows (the one you don't want) and hit ctrl-w.

Remember to save the workbook the way you want or you'll be doing this again.

luke1438 wrote:

Someone in my office sent an Excel file to me. When I open it two files
open one has the extension .xls:1 and the other .xls:2. They appear to
be the same file, I cannot delete either one without the other one
being deleted. Renaming and doing a save-as only compounds the problem,
I then have two more files with the :1 and :2 after the file extension.

Any helpful ideas on how to get just one file would be greatly
appreciated.

Thanks

--
luke1438
------------------------------------------------------------------------
luke1438's Profile: http://www.excelforum.com/member.php...o&userid=18407
View this thread: http://www.excelforum.com/showthread...hreadid=395065


--

Dave Peterson


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

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