Solution : https://service.sap.com/sap/support/notes/1498919 (SAP Service marketplace login required)
Summary :
SAP Note addresses limitations in BExAnalyzer with Excel 2010, highlighting issues like opening Excel 2007 workbooks and crashing during save operations with Excel 2010. The root cause is identified as changes in Excel 2010 affecting certain file formats due to complex workbook content, and systems running 32-bit versions or having insufficient RAM. Workarounds involve opening workbooks in Excel 2007 with specific settings enabled before transitioning to Excel 2010. It recommends setting up configurations to save files in Excel 2003 format to prevent issues related to newer file formats impacting BExAnalyzer functionality.
Key words :
workbooks priority recommendations / additional info category consulting validity software componentfrom rel, workbook compression 1322923 maintenance strategy / deadlines bw business explorer, 1322923 maintenance strategy / deadlines bw business explorer, bw frontend patch delivery schedule, __%pdfstyle%__ / } symptom limitation, / __%pdfstyle%__font-size, customer component bw-bex-, workbook settings dialog set, sap notes 1703251 bex sp, users save bex workbooks
Related Notes :
| 1703251 | BEx SP : Arrangement of packages in the Marketplace |
| 1643646 | |
| 1581104 | Workbooks created in Excel2007 cannot be opened in Excel2010 |
| 1577725 | |
| 1424366 | BW 7.x Frontend (GUI 720): General Information & Limitations |
| 1373214 | BExAnalyzer: issues with workbook compression |
| 1322923 | Maintenance strategy / deadlines BW Business Explorer (BEx) |
| 1260213 | Performance problems during workbook opening in Excel 2007 |
| 1175947 | Known Limitations of Analyzer with Excel 2007 |
| 1085218 | NetWeaver 7.x BW Frontend Patch Delivery Schedule |