View documents on two monitors

[C. Moya]

How can I view two Excel documents that are currently open on two monitors.
Everytime I open a document each one seems to be contained weirdly in the
same window. I know I can start a new "instance" of Excel from the Start
Menu (this trick doesn't work with PowerPoint!)... but that is extremely
unweildy and unintuitive.
Word doesn't behave this way.

I thought Office 2007 would have addressed this long standing weird and
unintuitive behavior... but it hasn't (inexplicably).

 

[Ron Rosenfeld]

How can I view two Excel documents that are currently open on two monitors.
Everytime I open a document each one seems to be contained weirdly in the
same window. I know I can start a new "instance" of Excel from the Start
Menu (this trick doesn't work with PowerPoint!)... but that is extremely
unweildy and unintuitive.
Word doesn't behave this way.

I thought Office 2007 would have addressed this long standing weird and
unintuitive behavior... but it hasn't (inexplicably).

I don't know that I really understand your question. If the documents are
"currently open on two monitors" what problem do you have viewing them?

How are documents contained "wierdly" in the same window as opposed contained
normally?

I'd guess that if you don't want to have multiple instances of Excel running,
what you could do is stretch your single instance of Excel across both
monitors, and then open multiple windows within that instance. At least it
works on my system.
--ron

 

[C. Moya]

I don't know that I really understand your question. If the documents are
"currently open on two monitors" what problem do you have viewing them?

How are documents contained "wierdly" in the same window as opposed
contained
normally?

I'd guess that if you don't want to have multiple instances of Excel
running,
what you could do is stretch your single instance of Excel across both
monitors, and then open multiple windows within that instance. At least
it
works on my system.
--ron

Open an Excel document from Windows Explorer. Open another one from Windows
Explorer. Try to see them on two monitors (in an INTUITIVE way.... not the
horrible stretch main window kludge).

(Unless you had the foresight to do this to begin with), you have to close
one of the documents. Open a new instance of Excel, and open the second
document using File | Open in the new instance.

Plus the workaround kludge above doesn't work with PowerPoint.

*sigh*

 

[Ron Rosenfeld]

Open an Excel document from Windows Explorer. Open another one from Windows
Explorer. Try to see them on two monitors (in an INTUITIVE way.... not the
horrible stretch main window kludge).

(Unless you had the foresight to do this to begin with), you have to close
one of the documents. Open a new instance of Excel, and open the second
document using File | Open in the new instance.

Plus the workaround kludge above doesn't work with PowerPoint.

*sigh*

It sounds as if what you want to do is to open separate instances of Excel with
each new document. You can certainly set up your file associations to do this.
It does use a lot of memory, however, so might not always be appropriate.

But if you really want to do that, as opposed to stretching the single instance
of Excel, what you do is

1. Open Windows Explorer
2. Tools/Folder Options/File Types
3. Scroll down to (or type) XLS (for extension) and select
4. Advanced
5. Select Open / Edit
6. The end will look something like ...EXCEL.EXE" /e or
...EXCEL.EXE" /e %1
7. Change the end to ...EXCEL.EXE" /e "%1"
8 DEselect Use DDE

Accept all the changes and you should be able to open each file in it's own
instance of Excel.

I don't know if this will work for PowerPoint.


--ron