Just a note: When I open all source files from "edit links" the data gets
updated.

"Asim" wrote:

Hi
I've created a workbook (let's call it Bucket) which fetches data from some
linked workbooks. However when I open Bucket I get error message '#VALUE!'.

What I have done is add a formula which is supposed to to do some
calculation in the other worksheet and then update information in Bucket.
Refreshing does not work and I've already changed the trust center settings
to automatcially update the data links.

What should I do...?