Hi

I know this is not a new query but I cannot find a solution to it anywhere and wondered whether there is one.
I have a summary workbook which is the destination book linked to 3 other source files.
When I have the destination book open any changes made in the source files updates ok.
When the destination book is closed and changes are made in any of the source files the destination file will not be updated.
This is a problem when one of the source files has rows added or deleted, it affects the formula which does not update to accommodate the new information.
Is there a way that this can happen automatically without having to go and check each time?
Thanks in advance for any help with this.
regards
Billy