View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Manual Recalculation

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