ExcelBanter

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

Meg

2 workbooks open
 
Hi -

A co-worker created a spreadsheet - over the course of a few weeks, several
tabs were added. Recently, when I received the spreadsheet via email, 2
identical workbooks opened. The 1st workbook was called 'Data (1)' and the
2nd was called 'Data (2)'.

There wasn't a macro on either spreadsheet - I'm at a loss to why 2
identical workbooks opened. Any ideas or suggestions are appreciated.

Regards,

Bob I

2 workbooks open
 
Close the second instance of the Workbook and then Save the file.

Meg wrote:
Hi -

A co-worker created a spreadsheet - over the course of a few weeks, several
tabs were added. Recently, when I received the spreadsheet via email, 2
identical workbooks opened. The 1st workbook was called 'Data (1)' and the
2nd was called 'Data (2)'.

There wasn't a macro on either spreadsheet - I'm at a loss to why 2
identical workbooks opened. Any ideas or suggestions are appreciated.

Regards,



David Biddulph[_2_]

2 workbooks open
 
It isn't two identical workbooks, it's two windows open on the same
workbook. Close one window, then save the workbook and reopen.
--
David Biddulph

"Meg" wrote in message
...
Hi -

A co-worker created a spreadsheet - over the course of a few weeks,
several
tabs were added. Recently, when I received the spreadsheet via email, 2
identical workbooks opened. The 1st workbook was called 'Data (1)' and
the
2nd was called 'Data (2)'.

There wasn't a macro on either spreadsheet - I'm at a loss to why 2
identical workbooks opened. Any ideas or suggestions are appreciated.

Regards,




Meg

2 workbooks open
 
Thank you - It worked!

"David Biddulph" wrote:

It isn't two identical workbooks, it's two windows open on the same
workbook. Close one window, then save the workbook and reopen.
--
David Biddulph

"Meg" wrote in message
...
Hi -

A co-worker created a spreadsheet - over the course of a few weeks,
several
tabs were added. Recently, when I received the spreadsheet via email, 2
identical workbooks opened. The 1st workbook was called 'Data (1)' and
the
2nd was called 'Data (2)'.

There wasn't a macro on either spreadsheet - I'm at a loss to why 2
identical workbooks opened. Any ideas or suggestions are appreciated.

Regards,



.



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

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