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

Automatic Calculation in Code Takes Longer than Worksheet
 

See if you have worksheet_change event code which may be running in a loop
because when you put in the time, you're changing the worksheet and this can
cause the event code to run again. If that's the case, precede the entry of
the time with
Application.EnableEvents = False
and turn it to true afterwards.
HTH
Bob Umlas

" wrote:

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

Automatic Calculation in Code Takes Longer than Worksheet
 

I tried disabling and enabling events and it was the same speed. Do you
think this might have to do with the user defined functions I have running?
Any other ideas?

Thanks

Adam Bush

"Bob Umlas, Excel MVP" wrote:

See if you have worksheet_change event code which may be running in a loop
because when you put in the time, you're changing the worksheet and this can
cause the event code to run again. If that's the case, precede the entry of
the time with
Application.EnableEvents = False
and turn it to true afterwards.
HTH
Bob Umlas

" wrote:

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

Automatic Calculation in Code Takes Longer than Worksheet
 

You could turn calculation off, but without actually having the workbook it's
hard to know what else is going on. It shouldn't be any slower in code than
without code, so something is certainly happening. Feel free to email me the
wb -- , and explain the issue. Use subject of "AllExpertsQ"

" wrote:

I tried disabling and enabling events and it was the same speed. Do you
think this might have to do with the user defined functions I have running?
Any other ideas?

Thanks

Adam Bush

"Bob Umlas, Excel MVP" wrote:

See if you have worksheet_change event code which may be running in a loop
because when you put in the time, you're changing the worksheet and this can
cause the event code to run again. If that's the case, precede the entry of
the time with
Application.EnableEvents = False
and turn it to true afterwards.
HTH
Bob Umlas

" wrote:

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