Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoCalculate at Defined Intervals
I have a huge spreadsheet that picks up market rates off the internet and then does all sorts of calculations. The market rates are updated every second and the whole thing is in constant recalculation mode. This slows my PC to a crawl. I am looking for a macro that will allow me to do the following: 1 Button to turn on Auto Recalc 1 Button to turn off Auto Recalc 1 Cell to define the interval in seconds between each recalc when Auto Recalc is Off. I should be able to enter 15 seconds into the cell and then click on the "Auto Recalc OFF" button and then the *Macro will count down 15 seconds and do "F9" every 15 seconds*. If you can help me, I will be very greatful and more if necessary. Thanks, PCDORK -- PCDork ------------------------------------------------------------------------ PCDork's Profile: http://www.excelforum.com/member.php...o&userid=32104 View this thread: http://www.excelforum.com/showthread...hreadid=518639 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoCalculate at Defined Intervals
Look at Chip Pearson's sit on Application.Ontime
http://www.cpearson.com/excel/ontime.htm you can set calculation mode with Application.Calculation = xlManual or Application.Calculation = xlAutomatic Application.Calculate triggers a calculation equivalent to F9 Using a macro to display a count down would just tie up your sheet even more. -- Regards, Tom Ogilvy "PCDork" wrote in message ... I have a huge spreadsheet that picks up market rates off the internet and then does all sorts of calculations. The market rates are updated every second and the whole thing is in constant recalculation mode. This slows my PC to a crawl. I am looking for a macro that will allow me to do the following: 1 Button to turn on Auto Recalc 1 Button to turn off Auto Recalc 1 Cell to define the interval in seconds between each recalc when Auto Recalc is Off. I should be able to enter 15 seconds into the cell and then click on the "Auto Recalc OFF" button and then the *Macro will count down 15 seconds and do "F9" every 15 seconds*. If you can help me, I will be very greatful and more if necessary. Thanks, PCDORK -- PCDork ------------------------------------------------------------------------ PCDork's Profile: http://www.excelforum.com/member.php...o&userid=32104 View this thread: http://www.excelforum.com/showthread...hreadid=518639 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autocalculate | Excel Discussion (Misc queries) | |||
Autocalculate | Excel Worksheet Functions | |||
Add same set of formulae at defined intervals to list of row data | Excel Worksheet Functions | |||
AutoCalculate and UDF | Excel Programming | |||
AutoCalculate | Excel Programming |