We have had a couple of incidents lately where calculations or headings do not appear to be working correctly but when the workbook is closed and re-opened they have corrected. 

This is a glitch in Excel possible from some new update. The simple fix is to select F9 (the 'recalculate' shortcut) and the links or cells will update.