Hi all,

I have a workbook that is pulling financial data from several external source files. Formulas are set to calculate automatically. Upon opening my workbook, and agreeing to update all links, most of the linked cells update except for a lookup table that I use to populate a pie chart. This table includes COUNTIF and SUMIF formulas, pulling from the external source file. As soon as I open the source file itself, the lookup table and pie chart in my workbook will update, but this is an annoying extra step... Any ideas?

Thanks,
M