excel stops loading at 93%

Question

I have an excel file present in my downloads folder and its size is around 50 Mb. When I double click on it, it starts loading but stops at 93% (please see attached screenshot). I have Office 2016 installed and use Windows 7. Please assist. Thanks

***Moved from: Office / Excel / Other/unknown / Office 2016 ***

Answer 1

The file can be downloaded from the following location.

1. Click this link http://mca.gov.in/MinistryV2/master+details.html
2. click on 'View state-wise Company Master Data'
3. Select state as Maharashtra
4. Download Master Details of Companies registered: Maharashtra (excel format) (40.8 MB)

Please note that the file opens the first time, but not the second time onwards. For example I can open it on 4 Dec 2017 if I downloaded it on this day. But I won't be able to open it from 5 Dec onwards.

Answer 2

The file fetched from the internet is 40MB not 50MB. It opens fine and re-opens fine as long as the built-in data query is not run. 

Where I use Excel, data connections are not automatically enabled and refreshed by default. I suspect this isn't your case. This can be configured by going to Excel options / Trust center / External content / Prompt user about data connections.

So that could explain the problem. Disable data connections so you can verify if the file loads entirely. And only then, as you are prompt for enabling data connections, can you enable and then refresh it.

Unfortunately, running this query implies that the database being targeted is accessible which is not my case (OLEDB datasource).

I suspect after each refresh the data could grow up significatively, and that could be seen after hitting save. Especially if you keep hitting refresh over and over again.

Additional suggestion : in theory, Excel does not save external linked values which is one way to explain why the file grows, but you can try to avoid that by going to Excel options / Advanced / "When calculating this workbook" and uncheck "Save external link values".

Answer 3

I did disable the data connection but the file failed to open.

Answer 4

"I did disable the data connection but the file failed to open." ==> very strange that you are still in trouble because the file has nothing in it that can possibly explain problems for opening it, especially if you have configured this file to manually enable data connections. This file opens on my computer in a matter of seconds (there are 5 million cells in it). My explanations :

• either this is what I believe which is a data query which either takes extremely long to complete, or never completes. Easy to diagnose.
• or the Excel version you are using has a flaw in it, since many updates may have destabilized the software. Very easy to fix : just try with an older version of Excel.