Click here to Skip to main content
15,039,470 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi All,

I am trying to open a large xml file in Excel with the same file. The file is approximately 8000 rows of data across 15 columns. The error is "Problems during load", but in the details, only "Unknown" is displayed. When the xml file is splited according to status(assigned,completed,inreview), each can be opened individually with no problem, so it doesn't seem to be either bad data or an incorrect xml format.

What I have tried:

I haven't tried any thing. Wondering if there a memory limit in Excel?
Updated 24-Jun-21 3:27am
Maciej Los 24-Jun-21 9:23am
8k rows and 15 columns shouldn't be a problem.
Member 15260968 24-Jun-21 9:26am
Earlier it used to load the data but from 3 days it is not loading the same error i am facing
Richard MacCutchan 24-Jun-21 9:26am
So what happened three days ago that changed the file?
Richard MacCutchan 24-Jun-21 9:26am
Send the details to Microsoft; it's their product.

1 solution

I'd try to open large XML file via import. See: Import XML data - Excel[^]

If it does not help, an Excel installation might be broken. In that case i'd suggest to Repair an Office application - Office Support[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900