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 Explore
Select "Tools
Select "Folder Options
Select the "File Types" Ta
Scroll down to find and select the XLS extensio
Click the "Advanced" Butto
Select the "Open" action from the lis
Click the "Edit..." Butto
Where is says "Application used to perform action:
If not already there, add
/e "%1
to the end of the file pat
Uncheck the "Use DDE" bo
Click O
Click O
Click Clos
That should do it
HTH
Elka
:
Previous Posts In This Thread:
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 200
Any thoughts?
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 Explore
Select "Tools
Select "Folder Options
Select the "File Types" Ta
Scroll down to find and select the XLS extensio
Click the "Advanced" Butto
Select the "Open" action from the lis
Click the "Edit..." Butto
Where is says "Application used to perform action:
If not already there, add
/e "%1
to the end of the file pat
Uncheck the "Use DDE" bo
Click O
Click O
Click Clos
That should do it
HTH
Elka
:
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
:
Thanks to both the respondants.
Thanks to both the respondants
That's an embarrasingly simple and obvious solution
-Cla
:
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
:
ClayMake note that interacting between two sessions of Excel can cause
Cla
Make note that interacting between two sessions of Excel can cause problems wit
some functions
i.e. copying and paste or paste special between files gives different result
than when running one session
Gord Dibben MS Excel MV
On Fri, 11 May 2007 16:36:01 -0700, Mr. Analog
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
Try Tools>Options>General.
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
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
RE: How can I open 2 excel files in two excel windows -using multi
Is it possible to put two excel TABS in different windows?
:
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
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
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
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.
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.
"
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
:
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
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
:
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.
:
I do not see the files option.
I do not see the files option. I am using Visat, I have organize>Folder
options, but no file types tab. Any suggestions?
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control
http://www.eggheadcafe.com/tutorial...9-c0b45fb68b78/creating-a-wpf-custom-con.aspx