Link to external file

  • Thread starter Thread starter Tadashii
  • Start date Start date
T

Tadashii

Hello,

I have some excel files wich contain links to other excel files. Ho
can Iprefent that when I open this excel file that excel is asking if
would like to update the linked cells.
Is there a VBA-instruction that I can run at startup of the file s
that the linked cells are automaticaly updated without excel asking fo
it?

Tadashi
 
There are 2 ways:
You can use
Application.AskToUpdateLinks = False
to have links always updated without prompt for all workbooks opened by
a user.

Or use
ThisWorkbook.UpdateLinks = xlUpdateLinksAlways
Then it works only for the current workbook.

But you do not need to use VBA:

To have links always updated without prompt for all workbooks opened by
a user:

On the Tools menu, click Options, and then click the Edit tab.
Clear the Ask to update automatic links check box. If the box is
cleared, the links are automatically updated, and no prompt is
displayed.

Only for the current workbook:

On Edit menu, click Links.
Click Startup Prompt.
Select "don't display the alert and update prompt"
 
Back
Top