SAP Knowledge Base Article - Public

2479321 - SAPListOfMessages does not return messages when open with Excel in a different language


  • Formula SAPListOfMessages was used in an AO workbook and it was saved in an English version Excel.
  • Open the workbook in a German version Excel later, Formula SAPListOfMessages does not return any messages that should be available.


  • SAP Business Objects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Enter the formula in a cell in AO Workbook, for example: =SAPListOfMessages("WARNING";TRUE) in an English version Excel.
  2. Save the AO workboook.
  3. Open this AO workbook ina  German version Excel.
  4. Refresh the AO workbook
  5. Formula SAPListOfMessages returns #WERT!


In the German version Excel, the formula is automatically set to =SAPListOfMessages("WARNING";WAHR)



To make the formula work in all regions, you can use for example:


instead of



Formula, Function, SAPListOfMessages, German, Excel, language, Analysis Office, AO, English , KBA , BI-RA-AO-XLA , Excel Addin , How To


SAP Analysis for Microsoft Office all versions