LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic Worksheet Calculation when Worksheet Name Changes Sabre472 Excel Worksheet Functions 1 April 9th 09 06:17 PM
Rerunning Macro takes longer after each consecutive use....Why MikeZz Excel Programming 3 April 12th 07 02:07 PM
Automatic Calculation on only one Worksheet sfrancoe2 Excel Discussion (Misc queries) 5 December 3rd 05 09:03 PM
Double-clicking cell with =A1 no longer takes you to A1 in v2003? GoDario27 Excel Discussion (Misc queries) 6 August 16th 05 03:31 PM
Automatic calculation of user-defined worksheet function Bart Deschoolmeester Excel Programming 2 October 8th 03 04:37 PM


All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"