Automation of Link Updates

[Sandman007]

In my spreadsheet I have data that is linked to other workbooks on the Local Area Network. Everytime I open up the spreadsheet I get a message asking me if I would like to enable macros in this spreadsheet and a message asking me if I want to update the linked information from the other workbooks.

How can I have Excel automatically update those linked workbooks upon opening the excel spreadsheet? I would like for the user to open the spreadsheet and upon it opening automatically update the linked information from those other linked workbooks. Please Help!

 

[dianemarie]

Hi Sandman, I believe if this can be set in Tools-Options-Edit tab. Deselect the setting "Ask to update automatic links". When a user opens a linked workbook it will just go ahead and open it without asking first. However, as far as I know, this has to be done individually on each PC, you can't set it globally if several people are accessing the same workbooks.