1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Least_Flounder
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#real-time data collaboration
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#google sheets
#financial modeling with spreadsheets
#intelligent data visualization
#automatic calculation mode
#cash flow model
#slow calculations
#resource hogs
#optimizing
#volatile formulae
#Excel performance
#VBA
#income progression