I have a very large file, 40KB, with a LOT of different formulas.
I am basically building a tool/small database within Excel for use.
All of a sudden I started seeing the calculating (8 threads) message and the lag time is unbearable.
- I cleared contents in unused rows/columns
- I do not have formulas that look up an entire row/column
- workbook includes - 9 tabs, all with different info
- largest tab uses 1500 row out to column BS.
- Power Query connects additional information from outside the file.
Any advise on how best to troubleshoot?
Your knowledge is welcomed and revered.
Thanks