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

How to check/improve for perfomance on workbook

So last week my colleague was working on some super simple reports files. But her laptop was getting super slow (not usual), we thought it was suddenly her laptop having issues and it didn't help that she also had a few workbooks open at the same time.

Now this week and I starting to use them and I am noticing a similar slowdown. So wondering what are some check and debugging we can do to check performance.

These are old reports file, my first assumption is that they used to have a few connections aren't in use anymore or they are named ranges that overlap. Overall the file is simple and self-contained, but the issue could arise when we add other tabs from other similar reports that keep the same named range name but reference the other file. (Think a file that calculates a country's cost and revenue and we need to add another one to do a comparison).

I guess I will start erasing those connections and named ranges first, but wondering what other checks are often done and how do you do performance checks (find which sheet or formula is taking the most compute power)

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#big data performance
#rows.com
#Excel alternatives for data analysis
#AI formula generation techniques
#self-service analytics tools
#Excel compatibility
#real-time data collaboration
#real-time collaboration
#formula generator
#Excel alternatives
#self-service analytics
#natural language processing for spreadsheets
#generative AI for data analysis
#performance
#workbook
#named ranges
#reports
#connections
#formulas
#slowdown