(Msg. 1) Posted: Fri May 11, 2007 1:58 pm
Post subject: How can I open 2 excel files in two excel windows -using multi mon Archived from groups: microsoft>public>excel>misc (more info?)
I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in
two instances of excel, each maximized to one monitor.
But when I open multiple spreadsheets they're all just documents within a
MDI type interface so they're all on the same monitor (and I don't want to
extend excel to cover multiple monitors b/c they are different sizes.
(Msg. 2) Posted: Fri May 11, 2007 3:50 pm
Post subject: RE: How can I open 2 excel files in two excel windows -using multi mon [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Start separate instances of Excel first, then open your documents from within
each respective instance.
However, if you really want to be able to open the files in separate
instances from Windows Explorer (doesn't work with desktop icons though),
then follow these steps:
Open Windows Explorer
Select "Tools"
Select "Folder Options"
Select the "File Types" Tab
Scroll down to find and select the XLS extension
Click the "Advanced" Button
Select the "Open" action from the list
Click the "Edit..." Button
Where is says "Application used to perform action:"
If not already there, add:
/e "%1"
to the end of the file path
Uncheck the "Use DDE" box
Click OK
Click OK
Click Close
That should do it.
HTH,
Elkar
"Mr. Analogy" wrote:
> I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in
> two instances of excel, each maximized to one monitor.
>
> But when I open multiple spreadsheets they're all just documents within a
> MDI type interface so they're all on the same monitor (and I don't want to
> extend excel to cover multiple monitors b/c they are different sizes.
>
> Excel 2003
>
> Any thoughts?
>
>
(Msg. 3) Posted: Fri May 11, 2007 3:51 pm
Post subject: RE: How can I open 2 excel files in two excel windows -using multi mon [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Open Excel then open one workbook. Open Excel again then open other
workbook. It works for me in 2003 to get two separate instances of Excel
going that are independent of one another.
"Mr. Analogy" wrote:
> I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in
> two instances of excel, each maximized to one monitor.
>
> But when I open multiple spreadsheets they're all just documents within a
> MDI type interface so they're all on the same monitor (and I don't want to
> extend excel to cover multiple monitors b/c they are different sizes.
>
> Excel 2003
>
> Any thoughts?
>
>
(Msg. 4) Posted: Fri May 11, 2007 4:36 pm
Post subject: RE: How can I open 2 excel files in two excel windows -using multi [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks to both the respondants.
That's an embarrasingly simple and obvious solution!
-Clay
"JLatham" wrote:
> Open Excel then open one workbook. Open Excel again then open other
> workbook. It works for me in 2003 to get two separate instances of Excel
> going that are independent of one another.
>
> "Mr. Analogy" wrote:
>
> > I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in
> > two instances of excel, each maximized to one monitor.
> >
> > But when I open multiple spreadsheets they're all just documents within a
> > MDI type interface so they're all on the same monitor (and I don't want to
> > extend excel to cover multiple monitors b/c they are different sizes.
> >
> > Excel 2003
> >
> > Any thoughts?
> >
> >
(Msg. 5) Posted: Fri May 11, 2007 7:43 pm
Post subject: RE: How can I open 2 excel files in two excel windows -using multi [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I wouldn't beat up on myself too much. The 'normal' use of Excel tend to
lead you away from such a solution. The fact that some applications only
permit one instance at a time to run (Outlook for instance), lead you further
away. Just glad we were able to help.
"Mr. Analogy" wrote:
> Thanks to both the respondants.
>
> That's an embarrasingly simple and obvious solution!
>
> -Clay
>
> "JLatham" wrote:
>
> > Open Excel then open one workbook. Open Excel again then open other
> > workbook. It works for me in 2003 to get two separate instances of Excel
> > going that are independent of one another.
> >
> > "Mr. Analogy" wrote:
> >
> > > I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in
> > > two instances of excel, each maximized to one monitor.
> > >
> > > But when I open multiple spreadsheets they're all just documents within a
> > > MDI type interface so they're all on the same monitor (and I don't want to
> > > extend excel to cover multiple monitors b/c they are different sizes.
> > >
> > > Excel 2003
> > >
> > > Any thoughts?
> > >
> > >
(Msg. 6) Posted: Sat May 12, 2007 9:46 am
Post subject: Re: How can I open 2 excel files in two excel windows -using multi [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Clay
Make note that interacting between two sessions of Excel can cause problems with
some functions.
i.e. copying and paste or paste special between files gives different results
than when running one session.
Gord Dibben MS Excel MVP
On Fri, 11 May 2007 16:36:01 -0700, Mr. Analogy
wrote:
>Thanks to both the respondants.
>
>That's an embarrasingly simple and obvious solution!
>
>-Clay
>
>"JLatham" wrote:
>
>> Open Excel then open one workbook. Open Excel again then open other
>> workbook. It works for me in 2003 to get two separate instances of Excel
>> going that are independent of one another.
>>
>> "Mr. Analogy" wrote:
>>
>> > I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in
>> > two instances of excel, each maximized to one monitor.
>> >
>> > But when I open multiple spreadsheets they're all just documents within a
>> > MDI type interface so they're all on the same monitor (and I don't want to
>> > extend excel to cover multiple monitors b/c they are different sizes.
>> >
>> > Excel 2003
>> >
>> > Any thoughts?
>> >
>> >
(Msg. 7) Posted: Mon May 14, 2007 11:40 am
Post subject: Re: How can I open 2 excel files in two excel windows -using multi [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
JLatham wrote:
> I wouldn't beat up on myself too much. The 'normal' use of Excel tend to
> lead you away from such a solution. The fact that some applications only
> permit one instance at a time to run (Outlook for instance), lead you further
> away. Just glad we were able to help.
>
But Outlook will let you open multiple windows of that single instance.
(Msg. 8) Posted: Mon Aug 06, 2007 11:42 am
Post subject: RE: How can I open 2 excel files in two excel windows -using multi mon [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I have Excel 2003 running on XP and I'd like to be able to run more than one
Excel application at a time. It will only let me run one instance with
multiple windows. Can anyone help me change the settings so I can open
multiple applications at one time?
All times are: Eastern Time (US & Canada) Goto page 1, 2, 3, 4
Page 1 of 4
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in
Office