Turn off Excel's 'want to update info?' prompts
 

Cheers all!

I kindly request your help with the following task:

I got two Workbooks with Range Names that refer to each other (i.e
Range Names in Workbook 1 refer to ranges in Workbook 2, and th
opposite).

The user will always open Workbook 1 first.
I have enabled Workbook 2 to open automatically when Workbook 1 i
opened (with the Workbook_Open event).

The 'problem':
As expected, when I'm opening Workbook 1 (thus causing Workbook 2 t
open as well) I'm getting prompts about whether I want to updat
Workbook1 with the info on Workbook 2.
The same prompt appears when Workbook 2 is opened automatically.

The task:
Is there any way that the updating takes place automatically in th
background for both Workbooks, and no prompts are shown to the user?

Thank you very much for your time!

Kind regards,
Ale

--
Alex Hatzisava
-----------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26812

Turn off Excel's 'want to update info?' prompts
 

in tools=Options, edit tab, unselect Ask to update automatic links.

--
Regards,
Tom Ogilvy

"Alex Hatzisavas" wrote in
message ...

Cheers all!

I kindly request your help with the following task:

I got two Workbooks with Range Names that refer to each other (i.e.
Range Names in Workbook 1 refer to ranges in Workbook 2, and the
opposite).

The user will always open Workbook 1 first.
I have enabled Workbook 2 to open automatically when Workbook 1 is
opened (with the Workbook_Open event).

The 'problem':
As expected, when I'm opening Workbook 1 (thus causing Workbook 2 to
open as well) I'm getting prompts about whether I want to update
Workbook1 with the info on Workbook 2.
The same prompt appears when Workbook 2 is opened automatically.

The task:
Is there any way that the updating takes place automatically in the
background for both Workbooks, and no prompts are shown to the user?

Thank you very much for your time!

Kind regards,
Alex


--
Alex Hatzisavas
------------------------------------------------------------------------
Alex Hatzisavas's Profile:
http://www.excelforum.com/member.php...o&userid=14559
View this thread: http://www.excelforum.com/showthread...hreadid=268123