Problems using Application.IgnoreRemoteReferences
 

Can someone please set me in the right direction.
I have recently added Application.IgnoreRemoteReferences to the
workbook open event to try to force users to open each Excel file in a
new instance of Excel. After I added the code and opened the file the
second time I get the message box that pops up that says "Existing
Remote Links Will Be Terminated".

1. Does anybody know why I get this message?
2. Is there a better way to force each Excel file to open in it's own
window.

** It should be noted that all of my code resides in an Add-In on a
network drive.

Any help would be greatly appreciated.
Thanks,
James

Problems using Application.IgnoreRemoteReferences
 

Hi,
I currently have the same issue in a particular book. I have checked all
external ref in the formulas and in the named ranges (menu Insert Name
Define), i have checked the books links. Nothing.
No time to investigate more, so, to prevent the message to appear, i am
using :
Application.DisplayAlerts = False
Application.IgnoreRemoteRequests = True
Application.DisplayAlerts = True

--
Regards,
Sébastien


"JGeniti" wrote:

Can someone please set me in the right direction.
I have recently added Application.IgnoreRemoteReferences to the
workbook open event to try to force users to open each Excel file in a
new instance of Excel. After I added the code and opened the file the
second time I get the message box that pops up that says "Existing
Remote Links Will Be Terminated".

1. Does anybody know why I get this message?
2. Is there a better way to force each Excel file to open in it's own
window.

** It should be noted that all of my code resides in an Add-In on a
network drive.

Any help would be greatly appreciated.
Thanks,
James

Problems using Application.IgnoreRemoteReferences
 

Thanks Sebastien but I had previously tried that and it does suppress
the message but it stops me from being able to reopen the file after I
close it down.