How to open vista excel in multiple windows versus 1 window?


Ad

Advertisements

F

Frank

I have Office 2007 Business installed in Vista and would like to be able to
double click on individual Excel workbooks that then open in separate Excel
programs (windows). Please explain how to do this as all help and support
that I have gone through fail to address this very popular application.
Thanks

Frank
 
J

JP

You could open several workbooks, then use the window arranging
feature to position them within the main Excel window. Why would you
want to open multiple instances of Excel?

--JP
 
I

Irked like the others.

We want it because we need it. Forcing me to run ONE "window" of PPT or excel
is a waste of my real-estate. I need to compare in different sized windows,
the information. If I wanted Windows 3.1 so I had to full screen every
application then I would not use XP. I need separate instances of Excel AND
powerpoint. period. Why? because I do; All of us who do not use the
fill-your-screen-and-make-other-windows-useless users do. Those of us with
different resolution multiple monitors. why? get over it. Why would you NOT
want to be able to have them in two separate instances? Word can do it. Your
lame argument of "why would you want to" is beaten by your lack of
comprehension in why would we NOT want to?

This goes for Office 2003, 2007, XP and Vista. Fix the DDE issue so I don't
have to use "runas" and log in multiple time on a single computer to open
multiple instances of this .... . seriously. You insult the users when you
retort with your "I cannot comprehend it, so why would anyone ELSE want
chocolate and vanilla swirls in their ice cream?" answer. Make it happen.
Period. Seriously, I have 4 weeks and a couple days until I finish my degree,
then I will turn to Linux and Open Office 3.0.
- Why would I want to keep using a product that does not serve its purpose?
That is my answer. OO 3.0. DDE be damned. If I open in separate instances,
then DDE is NOT wanted between the instances. Fix it. really. I didn't buy
into that Windows ME, and ME2 (Vista) and I doubt Windows xyz will be better.
DirectX10 for 3d on desktop. Linux can do that already without DX10.
 
J

JP

I'm going to try and help you, in spite of your less than professional
attitude and your treatment of this conversation as an argument that
needs to be "won".

This group consists of unpaid volunteers, who donate their time to
help others with their Excel problems, and who aren't necessary
Microsoft super-fans. Your taunting is unwelcome.

If you want to open multiple instances of Excel, in order to view
spreadsheets in different Excel windows, just start a blank copy of
Excel and open your spreadsheet. Then start another blank copy, and
open another spreadsheet. Your current workaround is unnecessary.

The reason why you wouldn't want this is twofold:
1) Excel has a built-in feature for viewing multiple workbooks, which
I briefly outlined in my previous post.
2) Every instance of Excel requires 100% more memory (I believe 32MB
per copy).

PowerPoint (like Outlook) is different; you can only run one copy at a
time. Again, there are already established methods for working on
multiple presentations -- just switch between them.
 
Ad

Advertisements

I

Irked like the others.

Humble apologies JP. That was aimed at Microsoft, not you.
I have word and excel in multiple separate windows which allow me to resize
them in different shapes and leave my desktop free to look at things in the
background. Also, when I close and open multiple excel files I don't have to
mess with the original file I am working on. The original post was from a web
forum that did not open in the view it did now, which shows public.excel...
I'll brose the public.powerpoint for some answers.

Why we would need Powerpoint in separate instances are for the same reason.
I cannot see anything in the background when I have to fullscreen the
application just to look at two pieces side by side. I cannot slip one half
way off the screen, resize it to a smaller window as overlay or side-by-side.
To that... what happens when you close one "window" ... the over-application
does not resize down, now one has to resize two additional windows to get it
back to a smaller size.
I forgot, after long lack of use of these forums that they are supported by
good people like you. I think I'll reactivate the office help thing to it
asks me for an opinion to make office better.. Wrong target.
And thanks for the extra info, that actually works. I have to do that with
Acrobat reader.

"J"
 
J

JP

I understand your concern, and as an experiment I tried my workaround
with PowerPoint. I opened PPT and created a new presentation. Then I
created another one. Then I went to Window>Arrange All and both of the
presentations displayed side by side. I could view them both. I also
restored the PPT window to normal (i.e. not minimized or maximized)
and could still work with both presentations.

HTH,
JP
 
R

realfoolguy

I'll present to you another option, and a clarification. I don't think you
are actually running multiple instances of Excel/etc, but rather just have
your settings so that each document you have opened has it's own bar on the
taskbar. This is not running multiple sessions of Excel/etc, which is indeed
a waste of resources, just displaying them differently.

In Office 2007, go here:
Office button in upper left-->Excel Options(or whichever product you are
in)-->Advanced-->Display.
In this area is the "Show all windows [...]" option. Try checking that box,
I think that'll get you what you want. The only thing you have to be careful
of (in earlier versions, haven't tried in 2007 yet) is to use the 'close
window' 'X' and not the 'close program' 'X' in the upper right hand corner
when you are done with one of the documents.
 
?

.

Microsoft loves to feed the public dog food. You take our apps the way we
make it or you'll have to figure out how to hack the settings on your own.
Anyway, you make the changes you need by following the steps below. I feel
your pain man.

Use the File Association Settings
You have to tell Excel not to use DDE to open the worksheet.
Open Windows Explorer, Tools, Options, File Types
Scroll down to XLS
Select Advance Button
Click on OPEN in the Actions window, Then Edit
On the 2nd line for application used add "%1".
Make sure to put the quotes around %1.
Example ...\Excel.exe" /e "%1"
Write down what you see in the DDE Section.
You will need this information if you want to return to the original settings.
Now DeSelect Use DDE
When you double click on any XLS file a separate instance of excel will run.
Another advantage is that you can open more than one XLS file with the same
name

realfoolguy said:
I'll present to you another option, and a clarification. I don't think you
are actually running multiple instances of Excel/etc, but rather just have
your settings so that each document you have opened has it's own bar on the
taskbar. This is not running multiple sessions of Excel/etc, which is indeed
a waste of resources, just displaying them differently.

In Office 2007, go here:
Office button in upper left-->Excel Options(or whichever product you are
in)-->Advanced-->Display.
In this area is the "Show all windows [...]" option. Try checking that box,
I think that'll get you what you want. The only thing you have to be careful
of (in earlier versions, haven't tried in 2007 yet) is to use the 'close
window' 'X' and not the 'close program' 'X' in the upper right hand corner
when you are done with one of the documents.

Irked like the others. said:
Humble apologies JP. That was aimed at Microsoft, not you.
I have word and excel in multiple separate windows which allow me to resize
them in different shapes and leave my desktop free to look at things in the
background. Also, when I close and open multiple excel files I don't have to
mess with the original file I am working on. The original post was from a web
forum that did not open in the view it did now, which shows public.excel...
I'll brose the public.powerpoint for some answers.

Why we would need Powerpoint in separate instances are for the same reason.
I cannot see anything in the background when I have to fullscreen the
application just to look at two pieces side by side. I cannot slip one half
way off the screen, resize it to a smaller window as overlay or side-by-side.
To that... what happens when you close one "window" ... the over-application
does not resize down, now one has to resize two additional windows to get it
back to a smaller size.
I forgot, after long lack of use of these forums that they are supported by
good people like you. I think I'll reactivate the office help thing to it
asks me for an opinion to make office better.. Wrong target.
And thanks for the extra info, that actually works. I have to do that with
Acrobat reader.

"J"
 
C

cclemp

Where would I find this in Vista. This had nver happened to me before, and I
have been using Vista/Office 07 since beta, and I could always view multiple
files and resize each of them on my desktop. AAAARRRGGG! What happened in the
last couple of wwek that changed this??????????????????????????????????????

. said:
Microsoft loves to feed the public dog food. You take our apps the way we
make it or you'll have to figure out how to hack the settings on your own.
Anyway, you make the changes you need by following the steps below. I feel
your pain man.

Use the File Association Settings
You have to tell Excel not to use DDE to open the worksheet.
Open Windows Explorer, Tools, Options, File Types
Scroll down to XLS
Select Advance Button
Click on OPEN in the Actions window, Then Edit
On the 2nd line for application used add "%1".
Make sure to put the quotes around %1.
Example ...\Excel.exe" /e "%1"
Write down what you see in the DDE Section.
You will need this information if you want to return to the original settings.
Now DeSelect Use DDE
When you double click on any XLS file a separate instance of excel will run.
Another advantage is that you can open more than one XLS file with the same
name

realfoolguy said:
I'll present to you another option, and a clarification. I don't think you
are actually running multiple instances of Excel/etc, but rather just have
your settings so that each document you have opened has it's own bar on the
taskbar. This is not running multiple sessions of Excel/etc, which is indeed
a waste of resources, just displaying them differently.

In Office 2007, go here:
Office button in upper left-->Excel Options(or whichever product you are
in)-->Advanced-->Display.
In this area is the "Show all windows [...]" option. Try checking that box,
I think that'll get you what you want. The only thing you have to be careful
of (in earlier versions, haven't tried in 2007 yet) is to use the 'close
window' 'X' and not the 'close program' 'X' in the upper right hand corner
when you are done with one of the documents.

Irked like the others. said:
Humble apologies JP. That was aimed at Microsoft, not you.
I have word and excel in multiple separate windows which allow me to resize
them in different shapes and leave my desktop free to look at things in the
background. Also, when I close and open multiple excel files I don't have to
mess with the original file I am working on. The original post was from a web
forum that did not open in the view it did now, which shows public.excel...
I'll brose the public.powerpoint for some answers.

Why we would need Powerpoint in separate instances are for the same reason.
I cannot see anything in the background when I have to fullscreen the
application just to look at two pieces side by side. I cannot slip one half
way off the screen, resize it to a smaller window as overlay or side-by-side.
To that... what happens when you close one "window" ... the over-application
does not resize down, now one has to resize two additional windows to get it
back to a smaller size.
I forgot, after long lack of use of these forums that they are supported by
good people like you. I think I'll reactivate the office help thing to it
asks me for an opinion to make office better.. Wrong target.
And thanks for the extra info, that actually works. I have to do that with
Acrobat reader.

"J"

:

I'm going to try and help you, in spite of your less than professional
attitude and your treatment of this conversation as an argument that
needs to be "won".

This group consists of unpaid volunteers, who donate their time to
help others with their Excel problems, and who aren't necessary
Microsoft super-fans. Your taunting is unwelcome.

If you want to open multiple instances of Excel, in order to view
spreadsheets in different Excel windows, just start a blank copy of
Excel and open your spreadsheet. Then start another blank copy, and
open another spreadsheet. Your current workaround is unnecessary.

The reason why you wouldn't want this is twofold:
1) Excel has a built-in feature for viewing multiple workbooks, which
I briefly outlined in my previous post.
2) Every instance of Excel requires 100% more memory (I believe 32MB
per copy).

PowerPoint (like Outlook) is different; you can only run one copy at a
time. Again, there are already established methods for working on
multiple presentations -- just switch between them.


On Oct 26, 8:50 am, Irked like the others. <Irked like the
(e-mail address removed)> wrote:
We want it because we need it. Forcing me to run ONE "window" of PPT or excel
is a waste of my real-estate. I need to compare in different sized windows,
the information. If I wanted Windows 3.1 so I had to full screen every
application then I would not use XP. I need separate instances of Excel AND
powerpoint. period. Why? because I do; All of us who do not use the
fill-your-screen-and-make-other-windows-useless users do. Those of us with
different resolution multiple monitors. why? get over it. Why would you NOT
want to be able to have them in two separate instances? Word can do it. Your
lame argument of "why would you want to" is beaten by your lack of
comprehension in why would we NOT want to?

This goes for Office 2003, 2007, XP and Vista. Fix the DDE issue so I don't
have to use "runas" and log in multiple time on a single computer to open
multiple instances of this .... . seriously. You insult the users when you
retort with your "I cannot comprehend it, so why would anyone ELSE want
chocolate and vanilla swirls in their ice cream?" answer. Make it happen.
Period. Seriously, I have 4 weeks and a couple days until I finish my degree,
then I will turn to Linux and Open Office 3.0.
- Why would I want to keep using a product that does not serve its purpose?
That is my answer. OO 3.0. DDE be damned. If I open in separate instances,
then DDE is NOT wanted between the instances. Fix it. really. I didn't buy
into that Windows ME, and ME2 (Vista) and I doubt Windows xyz will be better.
DirectX10 for 3d on desktop. Linux can do that already without DX10.
 
Ad

Advertisements

Joined
Jul 6, 2009
Messages
1
Reaction score
0
http://www.geniv.net/how-to-setup-microsoft-excel-2007-to-open-multiple-windows/2009/02/

This works, EXCEPT that you won't be able to double click on files because you'll get an error stating that "the file cannot be found". Make sense of that one if you can!! Ridiculous!! I'm still not sure how M$ is still in business....

Anyway, the workaround is that you can open Excel using your main Excel shortcut, then use the "Open" command to open your files. Then click on your shortcut again, and use the "Open" command. Do this for every file you want to open.

Ridiculous? Yes...
 

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