Serving the Quantitative Finance Community
Excel ricalculation
In a related question, does anyone know how to get Excel to automatically recalculate at given intervals? I would think that with fairly complex spreadsheets, an easy way to solve recalc problems would be to have them recalc every minute or 5 minutes or so. I haven't been able to find any such resource, however.
Excel ricalculation
Windy,I do something similar at the moment in order to retrieve external data. I have a Visual Basic dll with a timer that goes off every t seconds, which has a reference to a range object of the spreadsheet in question. If instead it had a reference to the Workbook object it could call it's calculate method.If this sounds like something you want to pursue let me know and I'll go in to more detail. You might be better waiting for a less-complicated solution however.Russ
Excel ricalculation
Recalculators,May I suggest the application.ontime method which is easily accessible and controllable from VBA.I've found lots of useful goodies athttp://www.cpearson.com/excel/ontime.htmand referenced links.Cheers,Socrates.
Excel ricalculation
Russell, if you would private mail me I would be interested in your method. Thanks Windy