Excel Issue: Links within a Workbook don't appear to update
 

My links to 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?