Updating Excel Links using Macro HELP!

[test1986]

Hi all,

I am in need of some major help. I have set up a large excel master sheet which has many formulas linked up to different sheets on My Documents. When i open the master sheet i askes if i would like to update the links. However i have now set up a link from all other sheets in my documents to the master sheet and when i change something on the master i need it to update all the links on the oher sheets without me opening them all and accepting the change.

Is there a way i can set up a macro to complete this manouver for me from the master sheet????

Any ideas or information would me majorly helpfull.

Cheers

[raypayette]

When you work on multiple workbooks, they have to be open to be updated. One good way to do this is to write an Auto_Open macro in the master that will open all linked workbooks.