Link Excel files with external references...

[cunger28]

I'm currently working on a project where accounting is updating budget models
in excel spreadsheets. I have a master excel sheet that contains references
to the budget spreadsheets for specific values that I parse out. I then link
to that master excel sheet in access for report building. Whenever I open
the master excel sheet in excel, I get the prompt that asks me if I want to
update my reference data. I update and all is well in excel. My question
is: when I run my reports through access, does the referenced information
update automatically with my linked table?

model1.xls\
model2.xls \
model3.xls ]-master.xls-access.mdb
model4.xls /
model5.xls/

I don't know if the above diagram helps illustrate my question....

Thanks in advance for any direction.

 

[John Nurick]

I'm pretty sure that the situation is this. When you run the report,
Access will use whatever values are saved in master.xls. It will not
pick up any changes made to the modelX.xls workbooks since master.xls
was last updated and saved.

A little testing will confirm or refute this.

I'm currently working on a project where accounting is updating budget models
in excel spreadsheets. I have a master excel sheet that contains references
to the budget spreadsheets for specific values that I parse out. I then link
to that master excel sheet in access for report building. Whenever I open
the master excel sheet in excel, I get the prompt that asks me if I want to
update my reference data. I update and all is well in excel. My question
is: when I run my reports through access, does the referenced information
update automatically with my linked table?

model1.xls\
model2.xls \
model3.xls ]-master.xls-access.mdb
model4.xls /
model5.xls/

I don't know if the above diagram helps illustrate my question....

Thanks in advance for any direction.