E Eva Nov 23, 2009 #1 When I press F9 I would like to calculate only the data in one sheet not in the whole book. How to do it?
When I press F9 I would like to calculate only the data in one sheet not in the whole book. How to do it?
T Teethless mama Nov 23, 2009 #3 SHIFT F9 calculates the active worksheet. CTRL ALT F9 calculates all worksheets in all open workbooks.
SHIFT F9 calculates the active worksheet. CTRL ALT F9 calculates all worksheets in all open workbooks.
