I have an excel file, let's call it A, that is linked to other source
files (say B). The worksheets in this file A are individually
protected. The problem I am having is everytime data in the source
file (B) changes file A is not authomatically updated. To update I
have to open file B the same time as file A. Is there not any better
way to link the 2 files so that update is authomatic? Or could this be
down to the fact that file A has protected worksheets??.

Please help.