•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Abnormal CPU and RAM usage
Our take
If you're experiencing abnormal CPU and RAM usage while working with a simple Excel file, you're not alone. Despite having a powerful Lenovo T14 with ample RAM, the jump in resource consumption during filtering can be perplexing. This issue can arise from various factors, including inefficient formulas, background processes, or Excel's handling of large datasets. To troubleshoot, consider optimizing your formulas, closing unnecessary applications, and checking for any updates to Excel. Exploring these avenues can help restore your system’s performance and enhance your productivity.
I've opened a simple excel file with 2000 rows max and about 100 columns. When I running a simple filter function (crtl + shift + L), the CPU usage goes from 1% to 100% and RAM from 300MB to 3GB. The system I'm using a Lenovo T14 5th Intel Core Gen Ultra 5 16GB RAM (also running on AC power with the BEST Performance preset). The file has no queries or connections. Just a simple xlookup formula for one column that pulls a result from another sheet that has 26 rows with 3 columns.
I'm puzzled why this is happening. Any pointers or remedies?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#rows.com#Excel alternatives for data analysis#financial modeling with spreadsheets#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#AI formula generation techniques#generative AI for data analysis#formula generator#big data performance#CPU usage#RAM usage#Excel file#filter function#xlookup formula#Lenovo T14#Intel Core Gen#16GB RAM#simple filter#Excel performance