Linked cells within a wokbook

A

Annamarie

I have a workbook with about 40 worksheets, there are links between the workbooks that sporadically do not update. I have checked the links when they freeze and have been unable to identify the cause. Eg cell c76=a number from a lookup table, is referenced throughout the workbook, in various functions. When c76 changes the functions freeze on the previous output of c76. The lookup table works and c76 changes accordingly, but the related functions do not. WHY
Thanks in advance
 
Top