Excel 2003: Multiple files open in single viewer

If I have one Excel file open (file A.xls) and then I want to copy over stuff from another one (file B.xls), it opens in the same Excel app instance. Thus, I have to go between different windows (from the menu options) to see + copy data over, etc. Likewise, if I attempt to close one, all open Excel files will also be forced to be closed.

My goal is to be able to use my dual monitor setup to be able to view two spreadsheets at the time, one per monitor. This seems to be specific to Office 2003 and I have no idea how to get rid of it. Any ideas? This has become very frustrating.

 

That frustrated me too!!!

here it is :
"Window" menu > "arrange "

 

!Quitter - Thanks for the workaround, that should serve my needs. It's too bad I'm constricted to just a few columns on either side but I'll take it!

Steve - Thanks for the pic. I just need to rid myself of the bad habit with the big X I guess.

 

aaah, ok!

If u open a new workbook when u already have an excel active session, it opens in the same excel session.
But if u instead click a second time on the excel program itself, it opens a second session, thus a second window. Then u chose the file to open

 

Is this problem unique to Excel office 2003?
Having multiple sessions running is allowed in Excel office 97 (Task Manager lists each session). As I'm writing this I have 4 sessions running, all sized to fit on one screen. I can copy and paste "from" and "to" all 4 views.

 

Not unique to office 2003 since I got office xp and the same "made-to-make-things-easier-but-it's-a-miss" excel behaviour.

It's like when M$ change the menus and I feel like being in a supermarket when they change the washing powder position to force you to visit all the shop.

 

I know that in Excel 2000 and Excel XP there is a View - Windows in Taskbar option. That checkbox basically turns it into multiple instances of Excel running. You might see if Excel 2003 has that.

~Kathie

 

Excel 2003 has that option available as well as Word 2003.

B