Error when exporting to excel

[alexveecode]

Trying to export our salesorder data from CRM 2016 8.2 on-prem
It crashes when trying the full set of 8800 records
But when doing a the first page of just 5000 records it works just fine

---

System.InvalidOperationException:
Cannot set a value on node type 'Element'.
FetchXML Builder
- Rappen.XTB.FetchXmlBuilder.AppCode.ExcelHelper.ExportClipboardToExcel(BackgroundWorker bw, String fetch, String layout, Boolean allpages, ConnectionDetail conndet, DataObject dataObj)
- Rappen.XTB.FetchXmlBuilder.AppCode.ExcelHelper.<>c__DisplayClass7_0.<ExportToExcel>b__0(BackgroundWorker w, DoWorkEventArgs a)
- System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
- System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

---

• XrmToolBox Version: 1.2025.10.74
• FetchXML Builder Version: 1.2025.12.1
• DB Version: 8.2.10.24
• Deployment: OnPremise

[alexveecode]

Interestingly, if I downgrade to version 1.2025.3.1 the behaviour and the error is different

In 2025.12 Excel doesn't even open

In 2025.3 Excel opens, and some (most?) of the data is there but there is this error:

Cannot set a value on node type 'Element'.

at System.Xml.XmlNode.set_Value(String value)
   at Rappen.XRM.Helpers.FetchXML.FetchXMLBase.ToXML()
   at Rappen.XRM.Helpers.FetchXML.Condition.<>c__DisplayClass11_0.<AddXMLProperties>b__0(Value a)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Rappen.XRM.Helpers.FetchXML.FetchXMLBase.ToXML()
   at Rappen.XRM.Helpers.FetchXML.Filter.<>c__DisplayClass13_0.<AddXMLProperties>b__0(Condition c)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Rappen.XRM.Helpers.FetchXML.Filter.AddXMLProperties(XmlElement xml)
   at Rappen.XRM.Helpers.FetchXML.FetchXMLBase.ToXML()
   at Rappen.XRM.Helpers.FetchXML.Entity.<>c__DisplayClass10_0.<ToXMLProperties>b__2(Filter f)
   at System.Collections.Generic.List`1.ForEach(Action`1 action)
   at Rappen.XRM.Helpers.FetchXML.Entity.ToXMLProperties(XmlElement xml)
   at Rappen.XRM.Helpers.FetchXML.FetchXMLBase.ToXML()
   at Rappen.XRM.Helpers.FetchXML.Fetch.AddXMLProperties(XmlElement xml)
   at Rappen.XRM.Helpers.FetchXML.FetchXMLBase.ToXML()
   at Rappen.XRM.Helpers.FetchXML.FetchXMLBase.ToString()
   at Rappen.XTB.FetchXmlBuilder.AppCode.ExcelHelper.ExportToExcel(XRMDataGridView xrmgrid, String fetch, String layout, FXBSettings settings, ConnectionDetail conndet)
   at Rappen.XTB.FetchXmlBuilder.DockControls.ResultGrid.OpenInExcel()

[alexveecode]

A workaround that seems to be working is to split the 8800 records into 2 pages
1st page grab 5000 records
2nd page grab 3300 records

Both excel files generate without issues. Then I have to manually merge them together

So I guess it is an issue of data volume?