Google Answers Logo
View Question
 
Q: Multiple Windows in Excel ( No Answer,   3 Comments )
Question  
Subject: Multiple Windows in Excel
Category: Computers > Software
Asked by: rtabell-ga
List Price: $10.00
Posted: 12 May 2006 20:10 PDT
Expires: 11 Jun 2006 20:10 PDT
Question ID: 728295
How do I have multiple workbook windows open in Excel 2003 whereby the
same instance of Excel is operating in two totally distinct windows
that can be moved about without a relation to a "main window".
Answer  
There is no answer at this time.

Comments  
Subject: Re: Multiple Windows in Excel
From: hammer-ga on 15 May 2006 07:54 PDT
 
To my knowledge, you can't. If you want two distinct windows, open a
second instance of Excel.

- Hammer
Subject: Re: Multiple Windows in Excel
From: madhanskumar-ga on 17 May 2006 10:56 PDT
 
Hi, not sure, if this is what you are looking for because i too had a
similar problem.  Check this and see..

"To open two distinct windows that can be moved without a relation to
main window" - On the menu bar click on..
Windows > New Window
Windows > Arrange Tiled/Horizontal/Vertical/Cascade.

Now there will be two window and one window will be static and other
will be dynamic.

"To open two distinct windows that can be moved with a relation to
main window" - On the menu bar click on..
Windows > New Window
Windows > Compare side by Side.

In the first case.. you need to close the instances one by one. Work
books will open like.. Book1:1, Book1:2, Book1:3 etc. If you close
excel without closing all instances, then everytime you open the excel
work book all the instances will get opened.

Good luck.
Subject: Re: Multiple Windows in Excel
From: bpothier-ga on 10 Nov 2006 09:47 PST
 
To force every Excel file you open from explorer to use a unique
instance of Excel, I went into Windows Explorer -> Tools -> Folder
Options -> File Types -> XLS -> Advanced -> "Open" -> Edit.
I then changed "Application used to..." to be:
".........\EXCEL.EXE" /e "%1"
(Add double quotes around %1, or files/dirs with spaces will fail to open)
Uncheck "Use DDE"  (it may come back with basic settings after you press OK)

Now each file I double-click on has its very own window, and I can
move them around independently, redize them, etc...

Brian

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy