What are the formulae like that you use to access the data? Some
functions do not work with closed workbooks.

Pete

On Nov 18, 2:45*pm, Frustrated
wrote:
I need to find out how to have Workbook A update automatically when opened
with data from Workbook B. *At this point when i open Workbook A it currently
asks if i would like for it to update and if i click yes, it doesn't update
it changes all my formulas to #VALUE. *But if i go open Workbook B myself,
Workbook A corrects itself. *How can i fix this?