A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Opening EXCEL Documents in separate Windows vs. a Shared Window



 
 
Thread Tools Display Modes
  #1  
Old December 29th, 2009, 05:13 PM posted to microsoft.public.excel.setup
Thomas195
external usenet poster
 
Posts: 1
Default Opening EXCEL Documents in separate Windows vs. a Shared Window

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.


  #2  
Old January 27th, 2010, 04:14 PM posted to microsoft.public.excel.setup
amy121
external usenet poster
 
Posts: 2
Default Opening EXCEL Documents in separate Windows vs. a Shared Window



"Thomas195" wrote:

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.


  #3  
Old January 27th, 2010, 04:15 PM posted to microsoft.public.excel.setup
amy121
external usenet poster
 
Posts: 2
Default Opening EXCEL Documents in separate Windows vs. a Shared Window

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!
  #4  
Old February 5th, 2010, 12:15 AM posted to microsoft.public.excel.setup
Derrick Crandell
external usenet poster
 
Posts: 1
Default Opening EXCEL Documents in separate Windows vs. a Shared Window

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

Previous Posts In This Thread:

On Tuesday, December 29, 2009 11:13 AM
Thomas195 wrote:

Opening EXCEL Documents in separate Windows vs. a Shared Window
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 have 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 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.

On Wednesday, January 27, 2010 10:14 AM
amy121 wrote:

"Thomas195" wrote:
"Thomas195" wrote:

On Wednesday, January 27, 2010 10:15 AM
amy121 wrote:

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/tutorials...windows-w.aspx
  #5  
Old February 5th, 2010, 02:20 PM posted to microsoft.public.excel.setup
Alpha_NSO
external usenet poster
 
Posts: 1
Default Opening EXCEL Documents in separate Windows vs. a Shared Window

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

"Thomas195" wrote:

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.