External links not updating
 

Hi,

I have a consolidation workbook that consolidates four other workbooks in the same folder. Once the lower level workbooks have been updated I can go into the consolidation, that simly uses SUM(full file path 1, full file path 2, etc) to sum the totals.

However, when I went into the consolidation the numbers were off by one workbook, i.e. it wasn't pulling them through. So after closing the consolidation, opening the one lower level workbook and saving then closing, before re-opening the consolidation - the numbers then flowed correctly.

My question is, why were the external links updating for all but one workbook?

Some background:
- all the lower level workbooks have been duplicated off a template - so they are identical.
- Consolidation has 'Update links to other documents' and 'Save external link values' ticked in Options.
- In Data-- edit links - check status comes back all 'ok' and pressing 'update links' doesn't change anything.
- I also have some code in workbook_open to look at the external workbooks and update the links:

ActiveWorkbook.UpdateLink Name:= _
"Full file path", _
Type:=xlExcelLinks

Application.Calculate

If anyone has an idea as to why this might be happening I would greatly appreciate it. To me it's bizzare that one or two will not update while others will. And obviously it's not great that it's unreliable.

Thanks in advance.