Hi!

I posted this problem in the programming section, but now that I think about it, there's not a lot of programming involved in the dilemma...

I created a linked workbook with many external references to cells in another workbook. However, after changes have been made to the source workbook and I've saved and closed it - when I open the linking workbook and choose to update, the cells do not change.

Here is an example of a reference in the linked workbook:

='C:\Documents and Settings\dollard\Desktop\[Updated_Metrics.xls]Stoplight_Chart'!D14

I'm not sure why the cells don't automatically update, can anyone help?

Thanks!

Dan