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

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

"Chris" wrote in message
...
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

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

On Tue, 16 Nov 2004 22:17:42 +0800, "Chris" wrote:

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