| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook split into two after opening
Hi,
A workbook that I am currently using at work keeps splitting into two workbooks, but only when I open it up. (When the workbook is not open, it only appears as one file, File.xls, in the file list.) After I open up File.xls, Excel splits it into two workbooks and in the top address bar calls them File.xls:1 and File.xls:2. If I make changes in one and save, it also saves the changes in the other one. How can I get it to be one workbook again? Thank you, Katherine |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook split into two after opening
This is one workbook with two open windows. To close one of the windows,
activate the window and then use the Ctrl+w shortcut to close it. The other window remains open, without the :1 suffix. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Katherine" wrote in message ... Hi, A workbook that I am currently using at work keeps splitting into two workbooks, but only when I open it up. (When the workbook is not open, it only appears as one file, File.xls, in the file list.) After I open up File.xls, Excel splits it into two workbooks and in the top address bar calls them File.xls:1 and File.xls:2. If I make changes in one and save, it also saves the changes in the other one. How can I get it to be one workbook again? Thank you, Katherine |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook split into two after opening
You have two windows open.
Close one by hitting the "X" on that window. Save the workbook. Close and re-open. Gord Dibben MS Excel MVP On Thu, 28 Dec 2006 10:01:00 -0800, Katherine wrote: Hi, A workbook that I am currently using at work keeps splitting into two workbooks, but only when I open it up. (When the workbook is not open, it only appears as one file, File.xls, in the file list.) After I open up File.xls, Excel splits it into two workbooks and in the top address bar calls them File.xls:1 and File.xls:2. If I make changes in one and save, it also saves the changes in the other one. How can I get it to be one workbook again? Thank you, Katherine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Volatile Macro for Adding Controls When Opening Workbook | Excel Discussion (Misc queries) | |||
| Image not loading when opening Workbook | Excel Discussion (Misc queries) | |||
| Updating LINKS when opening a workbook | Excel Worksheet Functions | |||
| Opening Excel with no workbook open | Excel Worksheet Functions | |||
| Why is workbook so slow opening? | Excel Discussion (Misc queries) | |||
Linear Mode
