Excel Question

[AricC]

Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.

[bartonc]

I gave up. I had the reverse problem (only wanted one window). Never did figure where they put that setting.

[AricC]

Barton what version are you using? I will let you know if I find a solution.

[MMcCarthy]

Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.

Aric

If I remember correctly this is a windows setting. For instance if you have windows running to open new window each time it will open new windows application each time. However, if you have windows to replace current window with new one it will open in the same application.

However, if you are doing this in code it is slightly different.

Mary

[AricC]

Aric

If I remember correctly this is a windows setting. For instance if you have windows running to open new window each time it will open new windows application each time. However, if you have windows to replace current window with new one it will open in the same application.

However, if you are doing this in code it is slightly different.

Mary

Mary,
I'm not doing this in code I'm talking about opening two spreadsheets in two seperate windows of excel. I want to do this so I can span two across two monitors and compare the data.

Thanks let me know if you have a fix for this,
Aric

[bartonc]

Aric

If I remember correctly this is a windows setting. For instance if you have windows running to open new window each time it will open new windows application each time. However, if you have windows to replace current window with new one it will open in the same application.
Mary

This makes perfect sense. It would be in keeping with M$'s integration strategy to make this an explorer setting and would explain why I was never able to find it.

[bartonc]

Barton what version are you using? I will let you know if I find a solution.

I use OpenOffice now. I don't buy any M$ software except the OS.

[MMcCarthy]

Mary,
I'm not doing this in code I'm talking about opening two spreadsheets in two seperate windows of excel. I want to do this so I can span two across two monitors and compare the data.

Thanks let me know if you have a fix for this,
Aric

Try this.

Open any windows folder then go to Tools - Folder Options. Under the General tab change the Browse Folders setting to 'Open each folder in it's own window'. You may have to reboot for the change to take effect.

Mary

[link]

Anyone know anything about Excel? When I open an Excel spreadsheet the program opens normally, when I open another spreadsheet it opens in the same Excel window. How do I get my new spreadsheets to open in new Excel window ( 2 Excel programs running)? I'm using Office 2003.

Hi Aric,

Try this one. In Excel, Go to Tools, Options, in View Tab, check on the Windows in Taskbar, then hit OK.

Hope this helps.

regards,

link :)

[MMcCarthy]

Hi Aric,

Try this one. In Excel, Go to Tools, Options, in View Tab, check on the Windows in Taskbar, then hit OK.

Hope this helps.

regards,

link :)

Great answer link.

I forgot that was there, sorry Aric.

Mary

[AricC]

Hi Aric,

Try this one. In Excel, Go to Tools, Options, in View Tab, check on the Windows in Taskbar, then hit OK.

Hope this helps.

regards,

link :)

Some combination of this and Mary's trick + rebooting worked on mine not my co-workers. Cooperate windows or die!

[MMcCarthy]

Some combination of this and Mary's trick + rebooting worked on mine not my co-workers. Cooperate windows or die!

I have a feeling it's one of those inconsistancies that can crop up in windows 'occasionally'.

Mary

[AricC]

I take it back the Windows in task bar only shows that you have two excel spreadsheets open. If you check/uncheck that you will have two spreadsheets not two excel programs. I'll continue looking and let you know if I find something. Again, we're looking to have 2 Excel programs open where we can show 2 spreadsheets side by side ( think dual monitors 1 spreadsheet a piece )


Thanks,
Aric

[MMcCarthy]

I take it back the Windows in task bar only shows that you have two excel spreadsheets open. If you check/uncheck that you will have two spreadsheets not two excel programs. I'll continue looking and let you know if I find something. Again, we're looking to have 2 Excel programs open where we can show 2 spreadsheets side by side ( think dual monitors 1 spreadsheet a piece )


Thanks,
Aric

You can do this by opening the application twice and then opening the spreadsheets from within the applications.

[AricC]

You can do this by opening the application twice and then opening the spreadsheets from within the applications.

Yeah but that is such a pain!