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