PC Review


Reply
Thread Tools Rate Thread

Open two Excel workbooks in separate windows?

 
 
Nigel M
Guest
Posts: n/a
 
      17th Dec 2004
How do you open two Excel 2003 workbooks in separate windows? I've got
dual monitors, and I want one on each.

TIA
--
Nigel M
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      18th Dec 2004
I don't use xl2003 and I don't use multiple monitors, but some people have
posted that by starting two separate instances of excel, it works ok.

But this is two instances of excel--not just two workbooks open in the same
instance.

There are tradeoffs. Copying between these two workbooks may not work like you
expect.

Nigel M wrote:
>
> How do you open two Excel 2003 workbooks in separate windows? I've got
> dual monitors, and I want one on each.
>
> TIA
> --
> Nigel M


--

Dave Peterson
 
Reply With Quote
 
Nigel M
Guest
Posts: n/a
 
      18th Dec 2004
In microsoft.public.excel, Dave Peterson wrote:

>some people have
>posted that by starting two separate instances of excel, it works ok.


If I open another file, I get both in the same instance. How do you
launch a second one?


--
Nigel M
 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      18th Dec 2004
I can start another instance by clicking on my shortcut to excel on my desktop.

I can also do it by:
windows start button|run|excel
and hit enter

If either of these fail to start a new instance, you can change a setting to see
if that helps.

Tools|Options|General|Ignore other applications (check it)

Be aware that one side effect of having this setting checked is sometimes you
can't open a file by double clicking on it in explorer. (toggle it back and
that should be reset.)

This shows up for workbooks that have spaces in their name or path:
c:\my documents\excel\testworkbook.xls
or
c:\test of workbook2.xls

cause trouble for me with this setting checked.

====
But you can't use File|open to open the second workbook. This will open in that
instance.

Nigel M wrote:
>
> In microsoft.public.excel, Dave Peterson wrote:
>
> >some people have
> >posted that by starting two separate instances of excel, it works ok.

>
> If I open another file, I get both in the same instance. How do you
> launch a second one?
>
> --
> Nigel M


--

Dave Peterson
 
Reply With Quote
 
Nigel M
Guest
Posts: n/a
 
      18th Dec 2004
In microsoft.public.excel, Dave Peterson wrote:

>I can start another instance by clicking on my shortcut to excel on my desktop.


D'OH! Thank you.


--
Nigel M
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I view separate windows for Excel workbooks on desktop Sooz Microsoft Excel New Users 2 11th Jul 2009 03:46 PM
Open Separate Excel Files in Separate Windows JTWood Microsoft Excel Misc 3 7th May 2006 11:18 PM
Open Excel files in separate sessions, not just separate windows? =?Utf-8?B?Qm9iIGF0IERleGlhIERlc2lnbg==?= Microsoft Excel Misc 1 18th Oct 2005 06:46 PM
How can I get existing Excel workbooks to open in separate windows =?Utf-8?B?Q2hyaXN0eTk5?= Microsoft Excel Worksheet Functions 1 22nd Mar 2005 01:26 AM
Re: Excel workbooks and separate windows Frank Kabel Microsoft Excel Misc 0 14th Jun 2004 10:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:53 AM.