Hi all,
I have a heavy workbook that has calculations set to manual but now has now refused to calculate sheets when I press the 'calculate sheet' button. Also turning back on automatic calculations doesnt work. It only recalculates when I manually select a cell's content and press enter. In addition, when the file is set to manual calculations it wants to calculate whenever I am saving (It never used to do that). Anyone know what could be the cause?
EDIT: I ask this in the VBA section because I have used code before that could explain why it isn't recalculating, such as this:
ThisWorkbook.Sheets("sheet1").EnableCalculation = True
But have since reversed the effect and removed the code.
Bookmarks