Values in excel not updating
The Edit Links dialog allows you to choose Automatic or Manual update only for OLE links.Excel links always have the Manual option button greyed out.
Click the ‘Startup Prompt’ button, and select one of these three: 1: Let users choose to display the alert or not Now, what happens at startup depends on another setting: Options General: Ask to update automatic links. To manually update values at any time while using a workbook, use Edit Links, and for each link click ‘Update Values’. The other type of Xl LInk Type is xl Link Type OLELinks, see below for those. To update them one by one and trap the error: You could call that macro in the Worksheet_Calculate event to update link values every time a recalculation happens.By default, Excel will recalculate its functions every time a cell value changes.However, the Calculation option can be set to switch off automatic recalculation, and once switched off, it is very easy for the user to forget about this option.If you get a prompt to update links when you open a workbook, but you cannot find any cells containing links, the link is probably in a name. If the source workbooks are open at the same time as the target, the formulas are part of the recalculation chain as normal.Use the Name Manager (either Excel’s own or the free third-party JKP Name Manager ) to check all names for links, particularly phantom links which are not used but clutter up the list. The link values from closed files are not refreshed in a recalculation.