Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic Worksheet Calculation when Worksheet Name Changes | Excel Worksheet Functions | |||
Rerunning Macro takes longer after each consecutive use....Why | Excel Programming | |||
Automatic Calculation on only one Worksheet | Excel Discussion (Misc queries) | |||
Double-clicking cell with =A1 no longer takes you to A1 in v2003? | Excel Discussion (Misc queries) | |||
Automatic calculation of user-defined worksheet function | Excel Programming |