Updating links in protected workbooks
I have a number of workbooks that I must lock and password protect (so folks
stop changing formulas). However these are linked to other source files. If
they go to Edit Links they cannot simply update the links, the only option is
to individually open the source files (which then updates the receiving
file). Is there some permission setting I can change to allow them to
manually update without opening all the source files?
Thanks,
Alan
|