Manual Recalculation

C

Chris

Dear all,

I have a file with thousands of formulas. Since I don't want
recalculation is done whenever I change values in some cells, I have set it
to manual recalculation. However, may I know if there are some ways to make
the file recalculate every 60 seconds? Or make a button on the page to
control recalculation?

Best Regards,
Chris
 
P

Paul B

Chris, you can just press F9 to recalculate, from excel help

Press F9 Calculates formulas that have changed since the last calculation,
and formulas dependent on them, in all open workbooks. If a workbook is set
for automatic calculation, you do not need to press F9 for calculation.

Press SHIFT+F9 Calculates formulas that have changed since the last
calculation, and formulas dependent on them, in the active worksheet.

Press CTRL+ALT+F9 Calculates all formulas in all open workbooks,
regardless of whether they have changed since last time or not.

Press CTRL+SHIFT+ALT+F9 Rechecks dependent formulas, and then calculates all
formulas in all open workbooks, regardless of whether they have changed
since last time or not.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2003
 
D

DC

Chris said:
I have a file with thousands of formulas. Since I don't want
recalculation is done whenever I change values in some cells, I have set it
to manual recalculation. However, may I know if there are some ways to make
the file recalculate every 60 seconds? Or make a button on the page to
control recalculation?
Click to expand...

First, set for manual calculation (Tools > Options > Calculation). Press F9
to manually recalculate.

Unfortunately, there are some weird side effects from using this feature. If
you open this file in the future, other files may also be set for manual
calculation. Basically, you may find some unexpected behaviors.
 
Top