Linked values not updating
Nel post
*James* ha scritto:
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.
Hi James,
Do you have macros on this workbook?
Maybe a macro set
Application.ScreenUpdating = False
without reverting it to True.
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|