Multiple Excel files

M

Mike

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can not copy a sheet to another book 7
Using Worksheet Name 3
Copying worksheet from hidden instance of Excel 1
How do I move multiple tabs in multiple workbooks to a master? 3
Compile data from several workbooks 1
'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010 2
Prevent multiple instances in Excel 2007 6
Multiple Instances in a Column 1

Top