Is there a way to figure out what formulae are being resource hogs?
I've inherited a model (well, technically dozens of models, but they all follow the same frameworks) which I can only assume has become bloated over time, to the point where changing one cell in automatic calculation mode could take 4-5 seconds to finish calculating. While I've gotten around this by working in manual mode for now, I'd like to start optimizing this for the future so I can keep it on automatic.
I've already done my best with the usual culprits (rogue conditional formatting, volatile formulae like OFFSET) but there's still a lot of slow calculations running to other sheets in the background. Is there any way to know what is calculating at each time, through VBA or otherwise?
For reference, power query unfortunately isn't an option because the issue isn't the data, but rather that it's a cash flow model tracking the progression of income - so it would require a lot of calculation chains by nature.
[link] [comments]
Want to read more?
Check out the full article on the original site