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.

I have discovered 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.



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