Opening EXCEL Documents in separate Windows vs. a Shared Window

T

Thomas195

I own Microsoft Office 2007 Home & Student, which provides me with three
installs at any time and I only use Word & Excel.

On my first machine, a notebook with XP, I had installed Office a few times
because of needing to reinstall Windows. I no longer have this machine.

On my second machine, a 64-bit notebook with XP, I've installed Office
several times because of: upgrading the hard drive twice, trying Vista before
going back to XP, trying Windows 7 RC and then finally purchasing and
installing Windows 7 Professional (64-bit).

The third machine, a new 64-bit desktop which shipped with Vista H.P. 64. I
installed 7 RC before ever putting Office 2007 on this machine. Now I have it
upgraded to 7 Home Premium and have installed Office.


The dozens of times that I have installed Office 2007, when I opened an
existing document (in any Office application), each document would open in
it's own window, each a completely separate instance of the application.
This has been the "default" operation on all of my machines, the machines at
my last employer, and the machines that I've been using at school this year.

On most boards, people seem to be shocked or surprised by this operation,
some saying it isn't possible and that multiple word or excel documents
always open up in a single instance of the software. I suppose each way has
it's own benefits.

With the Retail Release of Windows 7 (but not XP, Vista 32, Vista 64,
Windows 7 RC (7100) 32-bit, or Windows 7 RC (7100) 64-bit), when I install
Office 2007 and open existing documents (from double-clicking or right
clicking the file (or shortcut and selecting open), each Excel document now
opens in the same window (the same, shared instance of Excel 2007). However,
with Word, it still functions as it always has for me -- each document opens
in a new window, or "copy", of Word 2007. It doesn't matter if I install it
with no service packs, if I install only SP1, or if I install SP2, the same
thing happens.

I would like to know how to change Office applications' setup to allow me to
return Excel to it's previous default operation... opening a document from
it's shortcut and then other document and having each open in a new Excel
2007 Window. As I said, this has always worked this way on XP through
Windows 7 RC but no longer in Windows 7 RTM (full, retail release).

How do I change the operation of these applications?

Thank you for any help you can provide.
 
A

amy121

Thomas195 said:
I own Microsoft Office 2007 Home & Student, which provides me with three
installs at any time and I only use Word & Excel.

On my first machine, a notebook with XP, I had installed Office a few times
because of needing to reinstall Windows. I no longer have this machine.

On my second machine, a 64-bit notebook with XP, I've installed Office
several times because of: upgrading the hard drive twice, trying Vista before
going back to XP, trying Windows 7 RC and then finally purchasing and
installing Windows 7 Professional (64-bit).

The third machine, a new 64-bit desktop which shipped with Vista H.P. 64. I
installed 7 RC before ever putting Office 2007 on this machine. Now I have it
upgraded to 7 Home Premium and have installed Office.


The dozens of times that I have installed Office 2007, when I opened an
existing document (in any Office application), each document would open in
it's own window, each a completely separate instance of the application.
This has been the "default" operation on all of my machines, the machines at
my last employer, and the machines that I've been using at school this year.

On most boards, people seem to be shocked or surprised by this operation,
some saying it isn't possible and that multiple word or excel documents
always open up in a single instance of the software. I suppose each way has
it's own benefits.

With the Retail Release of Windows 7 (but not XP, Vista 32, Vista 64,
Windows 7 RC (7100) 32-bit, or Windows 7 RC (7100) 64-bit), when I install
Office 2007 and open existing documents (from double-clicking or right
clicking the file (or shortcut and selecting open), each Excel document now
opens in the same window (the same, shared instance of Excel 2007). However,
with Word, it still functions as it always has for me -- each document opens
in a new window, or "copy", of Word 2007. It doesn't matter if I install it
with no service packs, if I install only SP1, or if I install SP2, the same
thing happens.

I would like to know how to change Office applications' setup to allow me to
return Excel to it's previous default operation... opening a document from
it's shortcut and then other document and having each open in a new Excel
2007 Window. As I said, this has always worked this way on XP through
Windows 7 RC but no longer in Windows 7 RTM (full, retail release).

How do I change the operation of these applications?

Thank you for any help you can provide.
 
A

amy121

I am having the same issue in Excel 2007 with Windows 7. Any other work
arounds I have seen on the web, do not work. Please help!
 
D

Derrick Crandell

I too have 200+ users that are annoyed by this so Today I tested and tested until i found a solid solution. The option in excel to ?Ignore other applications that use Dynamic Data Exchange (DDE)? does not work, but the following does.

Step 1: Open my computer and click on Tools/ Folder Options.
Step 2: Select File Types and find XLS as well as XLSX (you will edit one at a time with same info below).
Step 3: highlight .XLS Microsoft Office Excel 97-2003 Worksheet & Click the Advanced button and select the Open action followed by clicking Edit.
Step 4: Delete whatever is in the ?DDE Message box?.
Step 5: Add the syntax ?%1? (with preceding space and include the quotes!) to the end of any existing string in the ?Application used to perform action:? box. (if you skip this, file names that contain spaces will not open properly)
Step 6: Save and close all and give it a try!

Derrick C.




Thomas195 wrote:

Opening EXCEL Documents in separate Windows vs. a Shared Window
29-Dec-09

I own Microsoft Office 2007 Home & Student, which provides me with thre
installs at any time and I only use Word & Excel

On my first machine, a notebook with XP, I had installed Office a few time
because of needing to reinstall Windows. I no longer have this machine

On my second machine, a 64-bit notebook with XP, I have installed Offic
several times because of: upgrading the hard drive twice, trying Vista befor
going back to XP, trying Windows 7 RC and then finally purchasing an
installing Windows 7 Professional (64-bit)

The third machine, a new 64-bit desktop which shipped with Vista H.P. 64.
installed 7 RC before ever putting Office 2007 on this machine. Now I have i
upgraded to 7 Home Premium and have installed Office

The dozens of times that I have installed Office 2007, when I opened a
existing document (in any Office application), each document would open i
it is own window, each a completely separate instance of the application
This has been the "default" operation on all of my machines, the machines a
my last employer, and the machines that I have been using at school this year

On most boards, people seem to be shocked or surprised by this operation
some saying it is not possible and that multiple word or excel document
always open up in a single instance of the software. I suppose each way ha
it is own benefits

With the Retail Release of Windows 7 (but not XP, Vista 32, Vista 64
Windows 7 RC (7100) 32-bit, or Windows 7 RC (7100) 64-bit), when I instal
Office 2007 and open existing documents (from double-clicking or righ
clicking the file (or shortcut and selecting open), each Excel document no
opens in the same window (the same, shared instance of Excel 2007). However
with Word, it still functions as it always has for me -- each document open
in a new window, or "copy", of Word 2007. It does not matter if I install i
with no service packs, if I install only SP1, or if I install SP2, the sam
thing happens

I would like to know how to change Office applications' setup to allow me t
return Excel to it is previous default operation... opening a document fro
it is shortcut and then other document and having each open in a new Exce
2007 Window. As I said, this has always worked this way on XP throug
Windows 7 RC but no longer in Windows 7 RTM (full, retail release)

How do I change the operation of these applications

Thank you for any help you can provide.

Previous Posts In This Thread:

Opening EXCEL Documents in separate Windows vs. a Shared Window
I own Microsoft Office 2007 Home & Student, which provides me with thre
installs at any time and I only use Word & Excel

On my first machine, a notebook with XP, I had installed Office a few time
because of needing to reinstall Windows. I no longer have this machine

On my second machine, a 64-bit notebook with XP, I have installed Offic
several times because of: upgrading the hard drive twice, trying Vista befor
going back to XP, trying Windows 7 RC and then finally purchasing an
installing Windows 7 Professional (64-bit).

The third machine, a new 64-bit desktop which shipped with Vista H.P. 64. I
installed 7 RC before ever putting Office 2007 on this machine. Now I have it
upgraded to 7 Home Premium and have installed Office.


The dozens of times that I have installed Office 2007, when I opened an
existing document (in any Office application), each document would open in
it is own window, each a completely separate instance of the application.
This has been the "default" operation on all of my machines, the machines at
my last employer, and the machines that I have been using at school this year.

On most boards, people seem to be shocked or surprised by this operation,
some saying it is not possible and that multiple word or excel documents
always open up in a single instance of the software. I suppose each way has
it is own benefits.

With the Retail Release of Windows 7 (but not XP, Vista 32, Vista 64,
Windows 7 RC (7100) 32-bit, or Windows 7 RC (7100) 64-bit), when I install
Office 2007 and open existing documents (from double-clicking or right
clicking the file (or shortcut and selecting open), each Excel document now
opens in the same window (the same, shared instance of Excel 2007). However,
with Word, it still functions as it always has for me -- each document opens
in a new window, or "copy", of Word 2007. It does not matter if I install it
with no service packs, if I install only SP1, or if I install SP2, the same
thing happens.

I would like to know how to change Office applications' setup to allow me to
return Excel to it is previous default operation... opening a document from
it is shortcut and then other document and having each open in a new Excel
2007 Window. As I said, this has always worked this way on XP through
Windows 7 RC but no longer in Windows 7 RTM (full, retail release).

How do I change the operation of these applications?

Thank you for any help you can provide.

:
:

I am having the same issue in Excel 2007 with Windows 7.
I am having the same issue in Excel 2007 with Windows 7. Any other work
arounds I have seen on the web, do not work. Please help!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Introduction to Windows Workflow Foundation 4.0
http://www.eggheadcafe.com/tutorial...e-04d037dcd7df/introduction-to-windows-w.aspx
 
A

Alpha_NSO

Hi, there is a sample for Office 2007 and Windows 7 64-bit.
When you click on excel file, you will see a command "Open separately"
Juct click it, and file will be opened in separate Excel window.

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open separately]

[HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open separately\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office12\\EXCEL.EXE\""
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,\
24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,\
00,54,00,4f,00,35,00,20,00,22,00,25,00,31,00,22,00,00,00,00,00


[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open separately]

[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open separately\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office12\\EXCEL.EXE\""
"command"=hex(7):76,00,55,00,70,00,41,00,56,00,35,00,21,00,21,00,21,00,21,00,\
21,00,21,00,21,00,21,00,21,00,4d,00,4b,00,4b,00,53,00,6b,00,45,00,58,00,43,\
00,45,00,4c,00,46,00,69,00,6c,00,65,00,73,00,3e,00,74,00,57,00,7b,00,7e,00,\
24,00,34,00,51,00,5d,00,63,00,40,00,49,00,49,00,3d,00,6c,00,32,00,78,00,61,\
00,54,00,4f,00,35,00,20,00,22,00,25,00,31,00,22,00,00,00,00,00
 

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