Move protected Excel file with links

[Kung Orne I]

Hello!
I have a Excel file (#1) with links to another Excel file (#2). #1 have protected sheets. I want to move #1 but then it´s not possible to uppdate the links between the files because of the protection. I have tried to open those cells where the links to #2 are located. But it does not work anyway.

Is the only way to solve this problem to unprotect the sheets? I don´t want to do that because there are many people involved in the file.

Thank you, Christian in Sweden (I´m sorry for my bad english. )

 

[Kung Orne I]

I now discowered that if I activate another sheet which is NOT protected when I update the links, this solve the problem. (But I will probably forget that several times in the future...)

But this will NOT solve my problem, because I have another sheet with protection and links, and I don´t want to unprotect any cells on this sheet.