Unable to update linked files

Giganews Newsgroups
Subject: Unable to update linked files
Posted by:  Ola2B (farou…@hotmail.com)
Date: Thu, 09 Aug 2007

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.