Connected sheets not updating

Hi,

Are you sure your system is set to Automatic Recalculation? Check under the Calculation Options on the ribbon.
If that's OK then go to the Excel Options Advanced (from the Office Button), scan down to the 'When calculating this workbook' option and make sure it's ticked. See attached picture

Failing that then I don't understand why the links wouldn't update so the pragmatic approach would be to just add an

ActiveWorkbook.Save

instruction after the

ActiveWindow.Close

instruction.

But I'm sure you'll find one of the first two will fix it