What is the most efficient to use macros to run iterations on a very large complex spreadsheet (100 meg)? Currently it takes about 15-20 seconds to re-calculate but I want to generate 100-150 scenarios of calculations with varying inputs. Should I use VBA to do this? Does it matter if the main spreadsheet is activated or not? I've created a monster but need to tame it - any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Minimizing re-calculation times
- Thread starter froesek
- Start date
Similar threads
- Question
