I have workbook that has quite a few links to values on other sheets within
the workbooks. For some reason the values aren't updating until I select the
cell with the link, select the formula and press enter to recalculate, it
then updates the linked value.

In the Caluclation tab in the Options menu, Automatic calculation has been
selected. Even when manual calculation is selected and I press F9 the values
don't update.

Any ideas?

Thanks, James.