View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] adambush4242@hotmail.com is offline
external usenet poster
 
Posts: 168
Default Automatic Calculation in Code Takes Longer than Worksheet

I have a macro that grabs the current time from a website and then brings it
into my worksheet. I put manual calculation on when I run this and it takes
less than a second. However, when I put the sheet back on auto calc, it
takes 53 seconds to recalculate. If i actually go into the worksheet, put it
on manual, type in the new time, and then put it back on auto it only takes 5
seconds to recalc. Any reason why there would be such a discrepency? I have
several user defined functions in the workbook, but they are being used by
either form of recalculation. Any help would be greatly appreciated.

Thanks

Adam Bush