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  

Need to open 2 Instances of Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 06:24 PM posted to microsoft.public.excel.setup
jvaughn75
external usenet poster
 
Posts: 2
Default Need to open 2 Instances of Excel 2007

I have a user that needs to open 2 spreadsheets in 2 different Excel windows.
She had the "Ignore other applications that use Dymanic Data Exchange (DDE)"
checked, allowing for multiple instances of Excell, but this function did not
allow her to double click a file to open in Excel. She would have to open
Excel, and open the file that way. Unchecking this box allows the files to
be opened by double clicking, but takes away the ability to open multiple
instances of Excel.

We, as a company, are migrating from Office 2003 to Office 2007 and the user
states she was able to do this in Excel 2003 with no problems. Did this
functionality change in Excel 2007, or are there more settings to check?
Thanks in advance for the help.
  #2  
Old April 21st, 2010, 11:53 PM posted to microsoft.public.excel.setup
Croft Mark
external usenet poster
 
Posts: 2
Default Need to open 2 Instances of Excel 2007

Hi,

To always start on a new instance, use this free utility:
http://orlando.mvps.org/ExcelFreeMore.asp?IdC=morewin

....and to keep an instance temporally in exclusive mode, use this two events
in
your workbook:

Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
End Sub

Regards,

Croft

"jvaughn75" wrote in message
...
I have a user that needs to open 2 spreadsheets in 2 different Excel
windows.
She had the "Ignore other applications that use Dymanic Data Exchange
(DDE)"
checked, allowing for multiple instances of Excell, but this function did
not
allow her to double click a file to open in Excel. She would have to open
Excel, and open the file that way. Unchecking this box allows the files
to
be opened by double clicking, but takes away the ability to open multiple
instances of Excel.

We, as a company, are migrating from Office 2003 to Office 2007 and the
user
states she was able to do this in Excel 2003 with no problems. Did this
functionality change in Excel 2007, or are there more settings to check?
Thanks in advance for the help.




  #3  
Old April 24th, 2010, 12:31 AM posted to microsoft.public.excel.setup
jvaughn75
external usenet poster
 
Posts: 2
Default Need to open 2 Instances of Excel 2007

I think I might have a better solution:

I was able to perform some tests in a virtual machine, using Windows 7 and
found that if I uninstall Office 2007, Uninstall Office 2003, and perform a
clean install of Office 2007, I was able to open 2 instances of Excell by
double clicking on the files. This came after I found another employee using
Office 2007 that did not upgrade, but performed a fresh install.

"Croft Mark" wrote:

Hi,

To always start on a new instance, use this free utility:
http://orlando.mvps.org/ExcelFreeMore.asp?IdC=morewin

....and to keep an instance temporally in exclusive mode, use this two events
in
your workbook:

Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
End Sub

Regards,

Croft

"jvaughn75" wrote in message
...
I have a user that needs to open 2 spreadsheets in 2 different Excel
windows.
She had the "Ignore other applications that use Dymanic Data Exchange
(DDE)"
checked, allowing for multiple instances of Excell, but this function did
not
allow her to double click a file to open in Excel. She would have to open
Excel, and open the file that way. Unchecking this box allows the files
to
be opened by double clicking, but takes away the ability to open multiple
instances of Excel.

We, as a company, are migrating from Office 2003 to Office 2007 and the
user
states she was able to do this in Excel 2003 with no problems. Did this
functionality change in Excel 2007, or are there more settings to check?
Thanks in advance for the help.




.

  #4  
Old April 24th, 2010, 10:41 PM posted to microsoft.public.excel.setup
Croft Mark
external usenet poster
 
Posts: 2
Default Need to open 2 Instances of Excel 2007

Weird, but if it worked is what matters.

"jvaughn75" wrote in message
...
I think I might have a better solution:

I was able to perform some tests in a virtual machine, using Windows 7 and
found that if I uninstall Office 2007, Uninstall Office 2003, and perform
a
clean install of Office 2007, I was able to open 2 instances of Excell by
double clicking on the files. This came after I found another employee
using
Office 2007 that did not upgrade, but performed a fresh install.

"Croft Mark" wrote:

Hi,

To always start on a new instance, use this free utility:
http://orlando.mvps.org/ExcelFreeMore.asp?IdC=morewin

....and to keep an instance temporally in exclusive mode, use this two
events
in
your workbook:

Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
End Sub

Regards,

Croft

"jvaughn75" wrote in message
...
I have a user that needs to open 2 spreadsheets in 2 different Excel
windows.
She had the "Ignore other applications that use Dymanic Data Exchange
(DDE)"
checked, allowing for multiple instances of Excell, but this function
did
not
allow her to double click a file to open in Excel. She would have to
open
Excel, and open the file that way. Unchecking this box allows the
files
to
be opened by double clicking, but takes away the ability to open
multiple
instances of Excel.

We, as a company, are migrating from Office 2003 to Office 2007 and the
user
states she was able to do this in Excel 2003 with no problems. Did
this
functionality change in Excel 2007, or are there more settings to
check?
Thanks in advance for the help.




.



  #5  
Old April 26th, 2010, 07:26 PM posted to microsoft.public.excel.setup
heycarolt
external usenet poster
 
Posts: 2
Default Need to open 2 Instances of Excel 2007

Hi, I'm using Excel 2003 and desperately need to open new instances of Excel
for each workbook. Where do I find the "Ignore other applications that use
Dymanic Data Exchange (DDE)" referred to in the original post?

Thanks in advance,
Carol

"Croft Mark" wrote:

Weird, but if it worked is what matters.

"jvaughn75" wrote in message
...
I think I might have a better solution:

I was able to perform some tests in a virtual machine, using Windows 7 and
found that if I uninstall Office 2007, Uninstall Office 2003, and perform
a
clean install of Office 2007, I was able to open 2 instances of Excell by
double clicking on the files. This came after I found another employee
using
Office 2007 that did not upgrade, but performed a fresh install.

"Croft Mark" wrote:

Hi,

To always start on a new instance, use this free utility:
http://orlando.mvps.org/ExcelFreeMore.asp?IdC=morewin

....and to keep an instance temporally in exclusive mode, use this two
events
in
your workbook:

Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
End Sub

Regards,

Croft

"jvaughn75" wrote in message
...
I have a user that needs to open 2 spreadsheets in 2 different Excel
windows.
She had the "Ignore other applications that use Dymanic Data Exchange
(DDE)"
checked, allowing for multiple instances of Excell, but this function
did
not
allow her to double click a file to open in Excel. She would have to
open
Excel, and open the file that way. Unchecking this box allows the
files
to
be opened by double clicking, but takes away the ability to open
multiple
instances of Excel.

We, as a company, are migrating from Office 2003 to Office 2007 and the
user
states she was able to do this in Excel 2003 with no problems. Did
this
functionality change in Excel 2007, or are there more settings to
check?
Thanks in advance for the help.



.



.

  #6  
Old April 26th, 2010, 07:32 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Need to open 2 Instances of Excel 2007

in 2003 it would be

ToolsOptionsGeneral Ignore other apllications.


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 11:26:01 -0700, heycarolt
wrote:

Hi, I'm using Excel 2003 and desperately need to open new instances of Excel
for each workbook. Where do I find the "Ignore other applications that use
Dymanic Data Exchange (DDE)" referred to in the original post?

Thanks in advance,
Carol

"Croft Mark" wrote:

Weird, but if it worked is what matters.

"jvaughn75" wrote in message
...
I think I might have a better solution:

I was able to perform some tests in a virtual machine, using Windows 7 and
found that if I uninstall Office 2007, Uninstall Office 2003, and perform
a
clean install of Office 2007, I was able to open 2 instances of Excell by
double clicking on the files. This came after I found another employee
using
Office 2007 that did not upgrade, but performed a fresh install.

"Croft Mark" wrote:

Hi,

To always start on a new instance, use this free utility:
http://orlando.mvps.org/ExcelFreeMore.asp?IdC=morewin

....and to keep an instance temporally in exclusive mode, use this two
events
in
your workbook:

Private Sub Workbook_Open()
Application.IgnoreRemoteRequests = True
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.IgnoreRemoteRequests = False
End Sub

Regards,

Croft

"jvaughn75" wrote in message
...
I have a user that needs to open 2 spreadsheets in 2 different Excel
windows.
She had the "Ignore other applications that use Dymanic Data Exchange
(DDE)"
checked, allowing for multiple instances of Excell, but this function
did
not
allow her to double click a file to open in Excel. She would have to
open
Excel, and open the file that way. Unchecking this box allows the
files
to
be opened by double clicking, but takes away the ability to open
multiple
instances of Excel.

We, as a company, are migrating from Office 2003 to Office 2007 and the
user
states she was able to do this in Excel 2003 with no problems. Did
this
functionality change in Excel 2007, or are there more settings to
check?
Thanks in advance for the help.



.



.


 




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 01:23 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.