ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How to open Multiple copies of excel 2003 from Explorer (https://www.excelbanter.com/setting-up-configuration-excel/182608-how-open-multiple-copies-excel-2003-explorer.html)

fred

How to open Multiple copies of excel 2003 from Explorer
 
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I click
on the next file it opens in the same excel, but on task bar it shows I have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view data
side by side. This is default behavior on my system for Word - every time I
click a word doc it opens a copy of word for each file.



I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks





JP[_4_]

How to open Multiple copies of excel 2003 from Explorer
 
You can toggle between workbooks by pressing Ctrl-Tab.

Is that what you were looking for?

--JP


On Apr 4, 8:00*pm, "fred" wrote:
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I click
on the next file it opens in the same excel, but on task bar it shows I have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view data
side by side. This is default behavior on my system for Word - every time I
click a word doc it opens a copy of word for each file.

I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks



fred

How to open Multiple copies of excel 2003 from Explorer
 
No

I want to be able to have 2 or more excel windows open side by side - like
the way word does it.

I can do it manually, by opening excel then go and open file, then open new
version of excel and open file, once I have 2 open I can rearrange on screen
so I see them side by side.

But this doesn't work if I open them from explorer - they all go to the same
excel.

"JP" wrote in message
...
You can toggle between workbooks by pressing Ctrl-Tab.

Is that what you were looking for?

--JP


On Apr 4, 8:00 pm, "fred" wrote:
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I click
on the next file it opens in the same excel, but on task bar it shows I
have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view data
side by side. This is default behavior on my system for Word - every time
I
click a word doc it opens a copy of word for each file.

I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks




Gord Dibben

How to open Multiple copies of excel 2003 from Explorer
 
When you have the two workbooks open in one instance of Excel, go to WindowNew
Window.

WindowArrangeVertical to have the two side by side.

Cuts down on the overhead of having two instances of Excel running.


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 21:57:24 -0400, "fred" wrote:

No

I want to be able to have 2 or more excel windows open side by side - like
the way word does it.

I can do it manually, by opening excel then go and open file, then open new
version of excel and open file, once I have 2 open I can rearrange on screen
so I see them side by side.

But this doesn't work if I open them from explorer - they all go to the same
excel.

"JP" wrote in message
...
You can toggle between workbooks by pressing Ctrl-Tab.

Is that what you were looking for?

--JP


On Apr 4, 8:00 pm, "fred" wrote:
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I click
on the next file it opens in the same excel, but on task bar it shows I
have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view data
side by side. This is default behavior on my system for Word - every time
I
click a word doc it opens a copy of word for each file.

I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks




fred

How to open Multiple copies of excel 2003 from Explorer
 
I want 2 instance of Excel running

I tried that I don't like it

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
When you have the two workbooks open in one instance of Excel, go to
WindowNew
Window.

WindowArrangeVertical to have the two side by side.

Cuts down on the overhead of having two instances of Excel running.


Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 21:57:24 -0400, "fred" wrote:

No

I want to be able to have 2 or more excel windows open side by side - like
the way word does it.

I can do it manually, by opening excel then go and open file, then open
new
version of excel and open file, once I have 2 open I can rearrange on
screen
so I see them side by side.

But this doesn't work if I open them from explorer - they all go to the
same
excel.

"JP" wrote in message
...
You can toggle between workbooks by pressing Ctrl-Tab.

Is that what you were looking for?

--JP


On Apr 4, 8:00 pm, "fred" wrote:
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I
click
on the next file it opens in the same excel, but on task bar it shows I
have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view
data
side by side. This is default behavior on my system for Word - every
time
I
click a word doc it opens a copy of word for each file.

I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens
blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks






JP[_4_]

How to open Multiple copies of excel 2003 from Explorer
 
Did you try FileOpen? What about selecting both files in the Explorer
and then pressing Enter? I don't recall offhand how to manually start
two instances of Excel.


--JP


On Apr 5, 10:01*am, "fred" wrote:
I want 2 instance of Excel running

I tried that I don't like it


fred

How to open Multiple copies of excel 2003 from Explorer
 
Seems the only way to do this is to open 2 instances of excel and then open
each file once excel is opened




"JP" wrote in message
...
Did you try FileOpen? What about selecting both files in the Explorer
and then pressing Enter? I don't recall offhand how to manually start
two instances of Excel.


--JP


On Apr 5, 10:01 am, "fred" wrote:
I want 2 instance of Excel running

I tried that I don't like it




Stuart Summerville

How to open Multiple copies of excel 2003 from Explorer
 
Its been a while since I did this, but...

In addition to the "Ignore other applications" option in Excel, you need
to disable use of DDE in Windows Explorer when launching xls files.

Explorer = Tools = Folder Options = File Types = XLS = Advanced =
Open = Edit
1) untick "Use DDE",
2) add a "%1" to the end of the "Application used" string above.

It works as you require, but IIRC doing Office Updates can revert it,
which then gets annoying.

Also annnoying that you have to do this per each extension (XLT etc...)
and Action per extension (New etc...).

HTH & HIW. :)

Stu.

On 5/04/2008 11:00 AM, fred wrote:
Excel 2003 SP3 - Plus all post hot fixes

When I am in explorer and click an excel file - excel opens - when I click
on the next file it opens in the same excel, but on task bar it shows I have
2 excel files opened. But it will not let me look at files side by side

I actual want it to open 2 or more copies of excel so that I can view data
side by side. This is default behavior on my system for Word - every time I
click a word doc it opens a copy of word for each file.



I turned on ToolsOptionsGeneral "Ignore other applications" this opens
different copies of excel but not the files I click on. Excel opens blank.

Tools - Options - View - Windows in Taskbar. this doesn't help either

I don't like the Compare side by side option under Window.

Thanks






All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com