Manual Recalculation

[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

 

[Bob]

You can simply add a calculate now button by customizing a toolbar(right
click any toolbar, customize,commands, tools calculate now. Or if you want
to do something fancy in VBA you can use application.calculate (I suggest
you search vba help for calculate to understand all of the optional types of
calculation that are supported)
HTH
Bob

 

[Myrna Larson]

I would think a button would be overkill. You can press F9 to recalculate.