How can I open 2 excel files in two excel windows -using multi mon

M

Mr. Analogy

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?
 
E

Elkar

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
 
J

JLatham

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.
 
M

Mr. Analogy

Thanks to both the respondants.

That's an embarrasingly simple and obvious solution!

-Clay
 
J

JLatham

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.
 
G

Gord Dibben

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
 
B

Bob I

JLatham said:
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.
 
E

Excel Newbie

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
 
G

Gord Dibben

Try Tools>Options>General.

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
 
W

woodms

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

Mike
 
D

Dave Peterson

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.
 
V

vijay

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
 
M

macropod

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
 
B

Brianna Winn

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
 
B

Brianna Winn

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.
 
G

Gord Dibben

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
 
T

Tim Coakley

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.
"
 
O

Otto Moehrbach

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
 
M

Marcy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top