Excel Workbook opening slowly

Copper Contributor

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...

3 Replies

@Kathleen99 

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.

Well now I've gone down another rabbit hole trying to get the Inquire COM Add-in. I have Office 365 but it is just not there....

@Kathleen99 

Availability depends on subscription

image.png

you may check here Office applications service description - Service Descriptions | Microsoft Docs