Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Excel files
I recently upgraded to 2003. When I open multiple files, it appears that
each file has it's own instance of Excel. In thepast it used to be that one instance could have multiple files. Also, it does not allow me to copy a worksheet from one file to another. Is this a bug or a setting somewhere. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Excel files
How are you opening the files?
1) Open Excel; use File | Open for FIle1 2) Use File | Open for FIle2 You should see FIle1 and FIle2 on the task bar 3) Use Windows | Arrange | tile Now you can see a worksheet form each file 4) Click the tab of source worksheet; hold CTRL and drag to the position on the other file's set of sheet tabs Hope this works for you -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Mike" wrote in message ... I recently upgraded to 2003. When I open multiple files, it appears that each file has it's own instance of Excel. In thepast it used to be that one instance could have multiple files. Also, it does not allow me to copy a worksheet from one file to another. Is this a bug or a setting somewhere. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query Multiple Excel files | Excel Discussion (Misc queries) | |||
Multiple Excel Files | Excel Discussion (Misc queries) | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) |