linked formulas
 

Hi I need help, I think I did everything to fix this but still not working.

I have a workbook that is linked to other workbooks. When I open workbook
"roster" it is supposed to update automatically to reflect the changes in the
other two workbooks and it has worked all along. However, lately i have
noticed that when I open "roster" it is not reflecting the changes. I must
either connect the source again or sometimes simply press update values.
This has to be done everytime there are changes to the other workbooks I
have set the edit links to update automatically and selected auto update in
the options tabs as well, still will not work. Please help me.

Thank You,
Brian

linked formulas
 

On Feb 8, 10:30*pm, Brian wrote:
Hi I need help, I think I did everything to fix this but still not working.

I have a workbook that is linked to other workbooks. When I open workbook
"roster" it is supposed to update automatically to reflect the changes in the
other two workbooks and it has worked all along. *However, lately i have
noticed that when I open "roster" it is not reflecting the changes. *I must
either connect the source again or sometimes simply press update values. *
This has to be done everytime there are changes to the other workbooks *I
have set the edit links to update automatically and selected auto update in
the options tabs as well, still will not work. *Please help me.

Thank You,
Brian

Have you checked the following?:
Tools| Options| Calculation tab, under workbook options, tick the
"Update remote references" and "Save external link values"
Another issue might be calculation in the same place as above, whether
it is set to manual or automatic.
HTH