Jul 28 2021 10:10 AM
I have about 20 identical workbooks for tracking cash flow. Of the 20, there is one that opens painfully slow (literally 5 minutes). It is approximately 3700 KB, whereas the others are 2000 KB even though they are almost identical. There are no Macros, charts, etc. Just a simple spreadsheet with 3 tabs. What can I check for to figure out what is causing this? All of the others work fine...
Jul 28 2021 10:25 AM
If you are on Excel 365 that could be wrong using of referenced with dynamic arrays if you enter something of =12:123456 instead of =12.123456. It could be dozens of reasons, check the workbook with Inquire.
Jul 28 2021 11:32 AM
Jul 28 2021 01:24 PM
Availability depends on subscription
you may check here Office applications service description - Service Descriptions | Microsoft Docs