Forum Discussion

99mils's avatar
99mils
Copper Contributor
Aug 29, 2023

Excel calculations too slow in tiny file

Hi all!

 

I have recently started using a new laptop and MS license account. Every Excel file I create runs painfully slow calculations, regardless of size and type of formulas within it. If I open the same file in a different computer, the file will still be slow. The same computer will open bigger, more complex files and calculate without issues.

 

As an example, I have a 200KB file with 10 tabs. Most tabs have hardcoded data and no more than 120 rows and 20 columns. Some have some simple SUM and XLOOKUP functions that look into the same tab. The larger tab has about 450 rows and 35 columns, out of which 30 are hardcoded data. The other columns have plus and minus formulas, one uses IFERROR and DAYS and two columns have the most complex formula in the file: IFNA with IFS embedded with three logical tests and XLOOKUPS into a different tab.

 

No macros, no external links, no queries, no conditional formatting. 

 

The files are all saved as .xlsx in my personal desktop. I'm using Excel version 2308 64-bit and my laptop has a 16GB RAM. I've uninstalled and re-installed MS office, reset my laptop, used three different MS office licenses and nothing solves the issues. I've also contacted my laptop support and MS technical support, but none could find anything.

 

Any ideas? 

 

Thanks

Resources