Forum Discussion
Workbook crashes after eliminate a XML source
I imported a xml source from a Mexican CFDI 4.0 invoice file into my workbook.
After the data import proceeded to delete the XML source from Developer tool, however the workbook crashes.
Which may be the cause?
- When you delete an XML source, if the workbook still has references or connections to that source, it can cause instability. Remove Data Connections: Go to Data > Connections and remove any lingering connections related to the XML source.
Check Queries: If you used Power Query, ensure that the query is removed or updated.
Deleting the XML source might have left behind broken references or links within the workbook.
Solution:
Clear Named Ranges: Go to Formulas > Name Manager and remove any named ranges that were linked to the XML data.
Check Formulas: Look for formulas or data validation rules that might still reference the deleted XML source.
