| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when i open an Excell file 3 workbooks open.Why? | Excel Discussion (Misc queries) | |||
| Can't Open Two Workbooks at the Same Time | Excel Discussion (Misc queries) | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| Open Close workbooks | Excel Discussion (Misc queries) | |||
| Is there a way to tab between open workbooks? | Excel Discussion (Misc queries) | |||
Linear Mode
