Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ron Bishop
 
Posts: n/a
Default Opening two separate instances of Excel

My users (who are accountants) use dual monitors and would like to open a
different Excel file on each monitor for the purposes of reviewing changes
between the two. I know that one method of doing this is by opening Excel
twice with its shortcut, then highlighting one Excel window and opening an
Excel file, then highlighting the other window and opening the other Excel
file. Unfortunately, the software that my users use to organize the Excel
files does not allow this to be done; it always opens every Excel file in the
first Excel window no matter which instance is highlighted. We had a similar
problem with Adobe Acrobat, but there is a command line switch that forces
Acrobat to open a new instance for each file.
Is there a similar switch for Excel, or some other method of forcing Excel
to open a new instance of itself for each file? We are running Excel 2003 on
Windows XP. Thank you in advance for your replies.
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

You might try going into the file associations (via Windows Explorer -
Tools, Folder Options, File Types) and for XLS files eliminate "uses DDE"
from the Open command. Replace it with a " %1" on the command line (after
the "/e").

--
Jim
"Ron Bishop" wrote in message
...
| My users (who are accountants) use dual monitors and would like to open a
| different Excel file on each monitor for the purposes of reviewing changes
| between the two. I know that one method of doing this is by opening Excel
| twice with its shortcut, then highlighting one Excel window and opening an
| Excel file, then highlighting the other window and opening the other Excel
| file. Unfortunately, the software that my users use to organize the Excel
| files does not allow this to be done; it always opens every Excel file in
the
| first Excel window no matter which instance is highlighted. We had a
similar
| problem with Adobe Acrobat, but there is a command line switch that forces
| Acrobat to open a new instance for each file.
| Is there a similar switch for Excel, or some other method of forcing Excel
| to open a new instance of itself for each file? We are running Excel 2003
on
| Windows XP. Thank you in advance for your replies.


  #3   Report Post  
Ted
 
Posts: n/a
Default

just what I was looking for and this one actually does work as prescribed!!
Thanks Jim and thanks to Ron for asking the question.
--
Thanks,
Ted


"Jim Rech" wrote:

You might try going into the file associations (via Windows Explorer -
Tools, Folder Options, File Types) and for XLS files eliminate "uses DDE"
from the Open command. Replace it with a " %1" on the command line (after
the "/e").

--
Jim
"Ron Bishop" wrote in message
...
| My users (who are accountants) use dual monitors and would like to open a
| different Excel file on each monitor for the purposes of reviewing changes
| between the two. I know that one method of doing this is by opening Excel
| twice with its shortcut, then highlighting one Excel window and opening an
| Excel file, then highlighting the other window and opening the other Excel
| file. Unfortunately, the software that my users use to organize the Excel
| files does not allow this to be done; it always opens every Excel file in
the
| first Excel window no matter which instance is highlighted. We had a
similar
| problem with Adobe Acrobat, but there is a command line switch that forces
| Acrobat to open a new instance for each file.
| Is there a similar switch for Excel, or some other method of forcing Excel
| to open a new instance of itself for each file? We are running Excel 2003
on
| Windows XP. Thank you in advance for your replies.



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
REF errors when opening excel in xp. works fine when opening wor. br Excel Discussion (Misc queries) 6 September 13th 05 11:41 AM
Problem opening Excel 2003 in a Small Business edition installing:function of Excel Excel Discussion (Misc queries) 1 April 11th 05 09:09 AM
Opening multiples instance of Excel VooDoo Excel Discussion (Misc queries) 1 March 9th 05 04:38 PM
error opening excel file jp New Users to Excel 1 February 19th 05 02:22 AM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 09:19 AM


All times are GMT +1. The time now is 07:08 PM.

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

About Us

"It's about Microsoft Excel"