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