I have a customer who uses QuickBooks Enterprise Solutions 18.0 in a terminal server farm environment.  There are three terminal servers total and all three have QBES 18.0 installed, as well as Microsoft Office ProPlus (aka Office 365 MSO v16.0.11126.20102 32-bit).  There are multiple users on these servers and all users are experiencing the same problem regardless of QB company file.

When attempting to export employee payroll data from Quickbooks (Reports menu -> Employees & Payroll -> Summarize Payroll Data in Excel), Excel reports "We found a problem with some content in 'QB_Payroll_Link.xlt'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

If the user clicks Yes, the workbook opens, but all of the Pivot Table data has been stripped.  If the user instead clicks No, the workbook does not open at all.

When opening the workbook after clicking Yes, Excel pops up a window showing the location of the .xml file containing the error displayed in the attached screenshot.

This export to Excel worked as recently as September, but is not working now.  I have been unable to find any information regarding this issue in my searches.  Do you have any ideas?