how do I stop excel from recalculating sheet every time I open one
EXCEL 2007
Office Button (top left hand corner)
Excel Options (lower right hand corner)
Formulas (on the left hand side) then, on the right hand side, in:-
Calculation options
- switch the Workbook Calculation to Manual then hit OK.
If my comments have helped please hit Yes.
Thanks.
Formulas (on left hand side) / then, on the
"seeing green" wrote:
Every time I open a spreadsheet it recalculates formulas so that means even
if I open one up to look at I now cant just x it out i have to say save, dont
save etc - another annoying step when I am in a hurry
|