Another thing to try is putting or calling RestoreSheetsCalculation in the Workbook_BeforeSave Event sub