worksheet protecting interefering with file links

[Guest]

Hi!
I have two separate excel files that are linked, and when i do not have any
password protection on the worksheets, i can save modified versions of one of
the files and use the "Edit" "Links" option to change the source file.
However, when i password protect the worksheets, i can no longer do this. Is
there a way around this so that i can have a protected worksheet with some
locked cells, but still be able to update file links?

 

[brandall]

If anyone has advice regarding this question i would very much
appreciate some sinsight as well. Thank you!