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?

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?

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?

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?

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?

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?

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.

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?

Thanks

Try ToolsOptionsGeneral.

Put a checkmark in "Ignore Other Applications"

Close Excel then double-click on a workbook file.

That should open one instance.

Double-click on another workbook file.

That should open second instance.


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 11:42:02 -0700, Excel Newbie <Excel
wrote:


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?

Thanks

Be advised that if you click this box in the Excel options it will
cause an issue with opening Excel attachments from Outlook.

Mike

On Aug 6, 12:59 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Try ToolsOptionsGeneral.

Put a checkmark in "Ignore Other Applications"

Close Excel then double-click on a workbook file.

That should open one instance.

Double-click on another workbook file.

That should open second instance.

Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 11:42:02 -0700, Excel Newbie <Excel



wrote:

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?

Thanks- Hide quoted text -

- Show quoted text -

Is it possible to put two excel TABS in different windows?

"Elkar" wrote:

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?

Two windows in the same instance of excel?

Window|New window
Window|Arrange Tiled (or horizontal or vertical)
Check "windows of active workbook"

When you decide to close one of these windows, select the window to close and
hit ctrl-w.



efif wrote:

Is it possible to put two excel TABS in different windows?

"Elkar" wrote:

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?



--

Dave Peterson

Hi,

when i did this like tools=options-genral-ignore the "ignore other application" it should not work, just like blank message..


I have tried this below option it works fantastic..

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:"


/e "%1"

to the end of the file path

Vijay


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Hi Tammy,

Given that the 'entire workbook is for one month', I take it that both
worksheets only have one month's data each. in that case, the following
array formula, pasted anywhere on your 'Store Totals' worksheet should do
the trick:
=SUM('Historical Data'!$C$2:OFFSET('Historical Data'!$C$2,$D$4+SUM(IF(MOD('Historical Data'!$B$2:OFFSET('Historical
Data'!$B$2,INT($D$4/5)*2+$D$4,),7)<2,1,))-1,))

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"vijay" wrote in message ...
Hi,

when i did this like tools=options-genral-ignore the "ignore other application" it should not work, just like blank message..


I have tried this below option it works fantastic..

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:"


/e "%1"

to the end of the file path

Vijay


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Gord,

That is what i have experienced. Do you know a fix for this? I have tried reversing the fix for having two files open in two windows, and I am unable to reverse the change.

It is imperative to my job that I am able to work in spread sheets, coping values, and formulas. With the size of the files that I work with, it is helpful to have two seperate windows open with excel, but I still need full use of copy/paste functions.

Thanks.

Brianna

I have found a temporary fix for this. If you still want to open two files in the same window, you have to open from within the file that is already open. That eliminates the problems with coping formula's, and column sizing.

Please post a message ID number or a google URL from the original to which
you are replying.

Or post enough quoted material so I get an idea of what you're wanting.


Gord Dibben MS Excel MVP

On Wed, 03 Sep 2008 11:24:20 -0700, Brianna Winn wrote:

Gord,

That is what i have experienced. Do you know a fix for this? I have tried reversing the fix for having two files open in two windows, and I am unable to reverse the change.

It is imperative to my job that I am able to work in spread sheets, coping values, and formulas. With the size of the files that I work with, it is helpful to have two seperate windows open with excel, but I still need full use of copy/paste functions.

Thanks.

Brianna

I followed these instructions and now anytime I try to open an excel file I get this error message:

"
'C:\Documents.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.
"

Tim
Keep your posts in the original thread. No one knows what you're
talking about. Provide more background if you want help in this thread.
HTH Otto
<Tim Coakley wrote in message ...
I followed these instructions and now anytime I try to open an excel file I
get this error message:

"
'C:\Documents.xls' could not be found. Check the spelling of the file
name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used
files on the File menu, make sure that the file has not been renamed,
moved, or deleted.
"

Hi Brianna,

I see that this string is old, but was wondering if you have found a fix for
this. I would like to have two windows of Excel (to have on two different
monitors) but encounter the copy/paste problem, as well as my Macros won't
work in the second window of Excel. Have you had any luck?

Thank you!
Marcy

"Brianna Winn" wrote:

Gord,

That is what i have experienced. Do you know a fix for this? I have tried reversing the fix for having two files open in two windows, and I am unable to reverse the change.

It is imperative to my job that I am able to work in spread sheets, coping values, and formulas. With the size of the files that I work with, it is helpful to have two seperate windows open with excel, but I still need full use of copy/paste functions.

Thanks.

Brianna

Marcy

Check out instructions at Chip Pearson's site for using two workbooks in a
single instance of Excel over dual monitors.

http://www.cpearson.com/excel/MultipleMonitors.aspx


Gord Dibben MS Excel MVP


On Tue, 10 Mar 2009 08:34:22 -0700, Marcy
wrote:

Hi Brianna,

I see that this string is old, but was wondering if you have found a fix for
this. I would like to have two windows of Excel (to have on two different
monitors) but encounter the copy/paste problem, as well as my Macros won't
work in the second window of Excel. Have you had any luck?

Thank you!
Marcy

"Brianna Winn" wrote:

Gord,

That is what i have experienced. Do you know a fix for this? I have tried reversing the fix for having two files open in two windows, and I am unable to reverse the change.

It is imperative to my job that I am able to work in spread sheets, coping values, and formulas. With the size of the files that I work with, it is helpful to have two seperate windows open with excel, but I still need full use of copy/paste functions.

Thanks.

Brianna

This is an ok work-around...but a little clumsy. My monitors are not the
same size (one is wide-screen). And also the status bar is only on the
lower-left hand corner of the application window. So, if there is not any
way to open two application windows that both have access to the
'personal.xls' file I'll still have to wait for it to come out in a further
upgrade.

Thanks for your help!
Marcy

"Gord Dibben" wrote:

Marcy

Check out instructions at Chip Pearson's site for using two workbooks in a
single instance of Excel over dual monitors.

http://www.cpearson.com/excel/MultipleMonitors.aspx


Gord Dibben MS Excel MVP

Sounds good except there is no "Tools" option under Windows 7 that I can find.

"Elkar" wrote:

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?

I do not see the files option. I am using Visat, I have organizeFolder
options, but no file types tab. Any suggestions?

"vijay" wrote:

Hi,

when i did this like tools=options-genral-ignore the "ignore other application" it should not work, just like blank message..


I have tried this below option it works fantastic..

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:"


/e "%1"

to the end of the file path

Vijay


EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

I followed your instructions to enable me open 2 windows alongside each other but all that has happened is they have all been minimised.

If I open excel book 1, then c/o New, it opens book 2 but on taskbar only.



Elka wrote:

Start separate instances of Excel first, then open your documents from within
11-May-07

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:

Previous Posts In This Thread:

On Friday, May 11, 2007 4:58 PM
MrAnalog wrote:

How can I open 2 excel files in two excel windows -using multi mon
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?

On Friday, May 11, 2007 6:50 PM
Elka wrote:

Start separate instances of Excel first, then open your documents from within
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:

On Friday, May 11, 2007 6:51 PM
HelpFrom wrote:

Open Excel then open one workbook. Open Excel again then open other workbook.
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:

On Friday, May 11, 2007 7:36 PM
MrAnalog wrote:

Thanks to both the respondants.
Thanks to both the respondants.

That's an embarrasingly simple and obvious solution!

-Clay

"JLatham" wrote:

On Friday, May 11, 2007 10:43 PM
HelpFrom wrote:

I wouldn't beat up on myself too much.
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:

On Saturday, May 12, 2007 12:46 PM
Gord Dibben wrote:

ClayMake note that interacting between two sessions of Excel can cause
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:

On Monday, August 06, 2007 2:42 PM
Excel Newbi wrote:

I have Excel 2003 running on XP and I'd like to be able to run more than one
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?

Thanks

On Monday, August 06, 2007 3:59 PM
Gord Dibben wrote:

Try ToolsOptionsGeneral.
Try ToolsOptionsGeneral.

Put a checkmark in "Ignore Other Applications"

Close Excel then double-click on a workbook file.

That should open one instance.

Double-click on another workbook file.

That should open second instance.


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 11:42:02 -0700, Excel Newbie <Excel
wrote:

On Thursday, August 16, 2007 12:55 PM
woodm wrote:

Be advised that if you click this box in the Excel options it willcause an
Be advised that if you click this box in the Excel options it will
cause an issue with opening Excel attachments from Outlook.

Mike

On Wednesday, October 10, 2007 4:57 PM
efi wrote:

How can I open 2 excel files in two excel windows -using multi
Is it possible to put two excel TABS in different windows?

"Elkar" wrote:

On Wednesday, October 10, 2007 5:51 PM
Dave Peterson wrote:

Two windows in the same instance of excel?
Two windows in the same instance of excel?

Window|New window
Window|Arrange Tiled (or horizontal or vertical)
Check "windows of active workbook"

When you decide to close one of these windows, select the window to close and
hit ctrl-w.



efif wrote:

--

Dave Peterson

On Wednesday, November 14, 2007 6:53 AM
vijay wrote:

how can i open two excel files in two excel windows
Hi,

when i did this like tools=options-genral-ignore the "ignore other application" it should not work, just like blank message..


I have tried this below option it works fantastic..

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:"


/e "%1"

to the end of the file path

Vijay

On Wednesday, September 03, 2008 2:24 PM
Brianna Winn wrote:

Problems coping with 2 excel files
Gord,

That is what i have experienced. Do you know a fix for this? I have tried reversing the fix for having two files open in two windows, and I am unable to reverse the change.

It is imperative to my job that I am able to work in spread sheets, coping values, and formulas. With the size of the files that I work with, it is helpful to have two seperate windows open with excel, but I still need full use of copy/paste functions.

Thanks.

Brianna

On Wednesday, September 03, 2008 2:37 PM
Brianna Winn wrote:

Found a fix
I have found a temporary fix for this. If you still want to open two files in the same window, you have to open from within the file that is already open. That eliminates the problems with coping formula's, and column sizing.

On Sunday, October 19, 2008 1:31 PM
Tim Coakley wrote:

Problem after using excel method mentioned above...
I followed these instructions and now anytime I try to open an excel file I get this error message:

"
'C:\Documents.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.
"

On Tuesday, March 10, 2009 11:34 AM
Marc wrote:

Hi Brianna,I see that this string is old, but was wondering if you have found
Hi Brianna,

I see that this string is old, but was wondering if you have found a fix for
this. I would like to have two windows of Excel (to have on two different
monitors) but encounter the copy/paste problem, as well as my Macros won't
work in the second window of Excel. Have you had any luck?

Thank you!
Marcy

"Brianna Winn" wrote:

On Tuesday, March 10, 2009 2:08 PM
Gord Dibben wrote:

MarcyCheck out instructions at Chip Pearson's site for using two workbooks in
Marcy

Check out instructions at Chip Pearson's site for using two workbooks in a
single instance of Excel over dual monitors.

http://www.cpearson.com/excel/MultipleMonitors.aspx


Gord Dibben MS Excel MVP


On Tue, 10 Mar 2009 08:34:22 -0700, Marcy
wrote:

On Friday, March 13, 2009 2:32 PM
Marc wrote:

This is an ok work-around...but a little clumsy.
This is an ok work-around...but a little clumsy. My monitors are not the
same size (one is wide-screen). And also the status bar is only on the
lower-left hand corner of the application window. So, if there is not any
way to open two application windows that both have access to the
'personal.xls' file I'll still have to wait for it to come out in a further
upgrade.

Thanks for your help!
Marcy

"Gord Dibben" wrote:

On Thursday, December 24, 2009 1:22 PM
Roger wrote:

Sounds good except there is no "Tools" option under Windows 7 that I can find.
Sounds good except there is no "Tools" option under Windows 7 that I can find.

"Elkar" wrote:

On Thursday, December 31, 2009 4:36 PM
DAvidMMM wrote:

I do not see the files option.
I do not see the files option. I am using Visat, I have organizeFolder
options, but no file types tab. Any suggestions?

"vijay" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control
http://www.eggheadcafe.com/tutorials...ustom-con.aspx