Slow Calculations

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

I have a massive worksheet with thousands of formulas. I use command buttons
to change my inputs. When ever I change one of my inputs it takes about 5
seconds for the result to fully calculate. Is their anyway to speed up excel
so I dont have a lag every time I make an inout change?

thanks,

Jase
 
Well, if you are just trying to change your inputs before the massive
recalculation can occur, you could switch to manual calculation.
Go to Tools|Options, Calculation tab, then check Manual calculation.
Remember, you need to calculate still after you have changed your inputs
(pressing F9 should work for you).
 
No, this won't work. I need to see the result after each tick to see if I
need to make further changes.
 
Well, without simplifying your formulas, not much you can do. It sounds like
you might have a situation where you want Solver, but I don't know much about
it, I am sure if you looked through the archives, you could come up with some
good Solver info.
 
Back
Top