Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 22nd 08, 03:40 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1
Default How to open Excel 2003 in separate Windows for multiple monitors

I use two monitors for my laptop. If I launch two instances of Excel, I can
drag one instance to the other monitor and work in two spreadsheets maximized
at one time. My coworker's Excel, on the other hand, opens one instance of
Excel, and all spreadsheets open in the same instance, and are each listed in
the "Windows" menu. So the only way she can view both sheets at one time is
to spread Excel over the length of both monitors and then arrange the windows
side-by-side within the same instance. Looking at previous posts, I thought
the solution was Tools - Options - View - Windows in Taskbar. However, hers
is already checked, the same as mine. In fact, we can't find any settings
that look any different between her setup and mine. Any ideas?

TIA

  #2   Report Post  
Old February 23rd 08, 12:23 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default How to open Excel 2003 in separate Windows for multiple monitors

ToolsOptionsGeneral "Ignore other applications" should do the trick and open
more than one instance of Excel.

Watch out you don't get too many instances or you will bog down.


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 07:40:01 -0800, RRozsa
wrote:

I use two monitors for my laptop. If I launch two instances of Excel, I can
drag one instance to the other monitor and work in two spreadsheets maximized
at one time. My coworker's Excel, on the other hand, opens one instance of
Excel, and all spreadsheets open in the same instance, and are each listed in
the "Windows" menu. So the only way she can view both sheets at one time is
to spread Excel over the length of both monitors and then arrange the windows
side-by-side within the same instance. Looking at previous posts, I thought
the solution was Tools - Options - View - Windows in Taskbar. However, hers
is already checked, the same as mine. In fact, we can't find any settings
that look any different between her setup and mine. Any ideas?

TIA


  #3   Report Post  
Old June 19th 08, 05:21 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2
Default How to open Excel 2003 in separate Windows for multiplemonitors

Is this a good idea? It disables DDE functionality.

Yes, it allows you to open multiple instances of Excel, but I can't even select a worksheet from my Start menu's DOCUMENTS list and have it launch Excel and load the selected worksheet.

Won't this also foul up merge capabilities with Word?
  #4   Report Post  
Old June 19th 08, 05:24 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2
Default How to open Excel 2003 in separate Windows for multiplemonitors

BTW, if you simply launch multiple instances of Excel, and then load the desired worksheets in the individual instances, you will fix your problem.

It's just a bit more cumbersome than being able to double-click on a file name and have it open in a separate window, but it works and you preserve DDE functionality.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying two or more excel 2003 windows on two monitors [email protected] Excel Discussion (Misc queries) 3 October 25th 06 07:20 PM
how can you open different excel files on multiple monitors? Tanmoy Excel Discussion (Misc queries) 0 July 11th 06 06:49 PM
Open Separate Excel Files in Separate Windows JTWood Excel Discussion (Misc queries) 3 May 7th 06 10:18 PM
Open Excel files in separate sessions, not just separate windows? Bob at Dexia Design Excel Discussion (Misc queries) 1 October 18th 05 05:46 PM
open multiple excel spreadsheets in separate windows by default Joe E via OfficeKB.com Setting up and Configuration of Excel 4 February 10th 05 06:33 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017