My links to cells in other worksheets within a workbook don't appear to be
updating
unless I close the workbook and re-open it. Automatic calculation is turned
on and F9 doesn't appear to do the trick. What could be causing this?

Background: The workbook is large with 100's of tabs and many thousands of
formulas. One trick that seemed to work on individual tabs was to do a
global find and replace of "=" with "=". Is there a better way??