Aug 28 2023 06:38 PM
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
Aug 28 2023 10:14 PM
Aug 28 2023 11:03 PM
Hi @Detlef Lewin, there are no hidden objects in the file.
Aug 28 2023 11:38 PM
Aug 28 2023 11:40 PM
Aug 29 2023 03:05 PM
Aug 29 2023 03:09 PM
Aug 30 2023 03:15 PM
Aug 31 2023 04:31 AM
IMHO, several times won't help. Alternative is full (clean) reinstall as here Repair an Office application - Microsoft Support