2693764 - BIRT Upgrade 4.3.2 - Error message when opening a report in .xlsx format - Ad Hoc Reporting

Run a report offline to Excel format .xlsx and receive a warning message in Excel as follows:

• SAP SuccessFactors Workforce Analytics
• Adhoc Reporting
• BIRT Upgrade

1. Run ReportX
1. Run Offline
2. Format: Excel
2. Go to Scheduled Reports / View Schedules in Report Centre
3. Open File
4. See above warning message from Excel: "We found a problem with some content in ReportX.xlsx. Do you want us to try and recover as much as we can? If you trust the source of this workbook, clixk Yes." 

There is no difference in the raw data but there is a difference in the way the data is grouped in a table. In 2.6.0, all the data are grouped under one table but in 4.3.2 the data’s are grouped in multiple tables with same column header based on some size or logic.

The message is not actually an error but just a warning. This is the reason why clicking on 'Yes' eventually loads the report.

You may check this link we found from Microsoft that is related to the message that is prompting:

https://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-problem-when-i-turn-on-share-option-on/17379b7c-2100-4ddf-a04d-251cc7a91424?db=5

The translation of the steps is go to 'Review' > Share Workbook > tick the 'Use the old shared workbooks feature instead of the new co-authoring experience.' under the 'EDITING' tab.

Then under the 'ADVANCED' tab > un-tick 'Filter Settings' > OK

 2684872 - Upgrade BIRT from version 2.6.0 to 4.3.2 - Ad Hoc - Q3 2018

Adhoc, Ad Hoc, BIRT, BIRT Upgrade 4.3.2, date/ time, Date Time, BIRT Template, Excel. , KBA , LOD-SF-ANA-BIR , BIRT Reports , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

SAP SuccessFactors HCM Core 1805 ; SAP SuccessFactors HCM suite all versions