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

[Alex Hatzisavas]

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

 

[Tom Ogilvy]

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