Primavera P6 Professional R8.2 EXPORT excel xml problem

if this just recently happened it maybe due to an update to excel from microsoft roll back the update

Thank you Zoltan. Should I roll back the updates of Excel from the server or on the client computers?

This issue has been resolved in the following Microsoft Windows updates:

• Windows 7 / Windows 2008 R2:
  • KB4048957 (Monthly Roll-up): https://support.microsoft.com/en-us/help/4048957/windows-7-update-kb4048957
    KB4048960 (Security-Only Update): https://support.microsoft.com/en-us/help/4048960/windows-7-update-kb4048960
• Windows 2012:
  • KB4048959 (Monthly Roll-up):  https://support.microsoft.com/en-us/help/4048959/windows-server-2012-update-kb4048959
    KB4048962 (Security-Only update):  https://support.microsoft.com/en-us/help/4048962/windows-server-2012-update-kb4048962
• Windows 2012 R2 / Windows 8.1:
  • KB4048958 (Monthly Roll-up):  https://support.microsoft.com/en-us/help/4048958/windows-81-update-kb4048958
    KB4048961 (Security-Only Update):  https://support.microsoft.com/en-us/help/4048961/windows-81-update-kb4048961
• Windows 10:
  • KB4048952:  https://support.microsoft.com/en-us/help/4048952
  • KB4048953:  https://support.microsoft.com/en-us/help/4048953
  • KB4048954:  https://support.microsoft.com/en-us/help/4048954/windows-10-update-kb4048954
• Windows 2016: 
  • KB4048953:  https://support.microsoft.com/en-us/help/4048953

How to get this update:

• This update will be downloaded and installed automatically from Windows Update.
• If you want to apply a standalone package for this update, refer to the associated KB links above for your operating system and click the link which will redirect you to the Microsoft Update Catalog.

there are 3 other work arounds

• Workaround 1:
  • Upgrade to a release of P6 Professional which does not utilize MS JET engine for the XLS integration.
    • Using r15.2, the x64 distribution uses the Microsoft Access Database Engine (ACE) driver for excel integration, which is not affected by the security patches.
    • Using r16.1, the x64 distribution uses the Microsoft Access Database Engine (ACE) driver for excel integration, which is not affected by the security patches.
    • Using r16.2 and later release version, both x64 and x86 utilize Open XML for excel integration, which is not affected by the security patches.
• Workaround 2:
  • Keep MS Security Patches applied and complete the following steps:
    1. Find prior version (4.0.9801.0) of msexcl40.dll
       • Note: Can search windows for references to the .dll than right-click, select Properties and the Details tab to determine version of driver.  If you do not have a copy of the older version, you can remove the security patches to obtain the version, then reapply the patches after completing below steps.
    2. Place in another directory.
       • Note: This can be placed in any directory, or the working directory of P6 Professional
    3. Open the registry editor (Start > run > regedit)
    4. Browse to: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel
    5. Double-click the 'Win32' string value and point to the location and name of the older msexcl40.dll copied to an alternate location in step b.
    6. Restart P6 Professional for the change to be picked up
• Workaround 3:
  • Remove the noted security patches:
    1. Browse to Control Panel > Programs and Features
    2. Click "View Installed Updates"
    3. Find and remove the noted security updates
       • Windows 7: KB4041681 & KB4041678
       • Windows 10: KB4041676