By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Excel Question

Expert 100+
P: 1,892
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.
Jan 5 '07 #1
Share this Question
Share on Google+
22 Replies


bartonc
Expert 5K+
P: 6,596
I gave up. I had the reverse problem (only wanted one window). Never did figure where they put that setting.
Jan 6 '07 #2

Expert 100+
P: 1,892
Barton what version are you using? I will let you know if I find a solution.
Jan 6 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 6 '07 #4

Expert 100+
P: 1,892
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
Jan 7 '07 #5

bartonc
Expert 5K+
P: 6,596
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.
Jan 7 '07 #6

bartonc
Expert 5K+
P: 6,596
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.
Jan 7 '07 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 7 '07 #8

link
P: 71
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 :)
Jan 8 '07 #9

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 8 '07 #10

Expert 100+
P: 1,892
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!
Jan 8 '07 #11

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 8 '07 #12

Expert 100+
P: 1,892
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
Jan 8 '07 #13

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Jan 8 '07 #14

Expert 100+
P: 1,892
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!
Jan 8 '07 #15

MMcCarthy
Expert Mod 10K+
P: 14,534
Yeah but that is such a pain!
Since you are actually trying to open two instances of the application there is really no way around this outside of using VBA code to do it for you.

Mary
Jan 8 '07 #16

link
P: 71
Thanks mmccarthy...

I really don't get it but try this one also, Aric.

if you already opened two excel program and trying to view two spreadsheets at the same time, right click on the taskbar then select tile windows horizontally or tile windows vertically.

hope I got it right.

Regards,

Link
Jan 9 '07 #17

bartonc
Expert 5K+
P: 6,596
Some combination of this and Mary's trick + rebooting worked on mine not my co-workers. Cooperate windows or die!
Or OpenOffice!
Jan 9 '07 #18

link
P: 71
Or OpenOffice!
I have Openoffice too! and it's portable...which means I can run OpenOffice without installing it. :D
Jan 9 '07 #19

Expert 100+
P: 1,892
Or OpenOffice!
Lol that's not an option.
Jan 9 '07 #20

Cstrike dish
P: 13
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
Hello everyone
This is my first time at this forum ( I have to tell you guys that i'm not good at writing lol. )
I agree with Mary very much!
Regards
Jacky.
Jan 11 '07 #21

P: 1
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.
See if this helps you:
http://www.drewery.net/blog/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003/
Feb 16 '07 #22

Expert 100+
P: 1,892
See if this helps you:
http://www.drewery.net/blog/2006/08/29/utilising-dual-monitors-with-microsoft-excel-2003/
Yeah actually I think that will work. Nice job been buggin me for awhile.
Feb 16 '07 #23

Post your reply

Sign in to post your reply or Sign up for a free account.