3667501 - Excel cell reference formula does not populate correctly across columns in SAC Excel Add-in reports

• This issue occurs when the "Add Rows/Columns" function is used.
• When using an external cell reference formula (e.g., =B8) in Table2 to reference values from Table1, the formula does not populate correctly across all row/column cells.
• Instead of displaying the respective column values, all cells in the new row/column of Table2 display the same value from the referenced cell (e.g., =B8).

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP Analytics Cloud, add-in for Microsoft Office

1. Open an Excel workbook containing two tables, Table1 and Table2, in the SAP Analytics Cloud Excel Add-in.
2. Select a row in Table1 and use the "Add Rows/Columns" function.
3. In the first cell of the new row, type an external reference formula (e.g., =B8).
4. Observe that the formula populates correctly across columns (e.g., =B8, =C8, =D8, etc.).
5. Select a row in Table2 and use the "Add Rows/Columns" function.
6. In the first cell of the new row, type an external reference formula (e.g., =B8).
7. Observe that the formula does not populate correctly across columns. Instead, all cells in the new row display the same value from the referenced cell (e.g., B8).

The external reference formula added to a new row in Table2 is treated as a single cell reference across all cells in the row, regardless of whether it is copied from Table1 or another range in Excel.

As an alternative, use the formula =XLOOKUP() in the target cell.

• Add rows/columns | SAP Help Portal
• 3079294 - Enhancement Request for SAP Analytics Cloud, add-in for Microsoft Office
• Roadmap SAP Analytics Cloud Add-in for Microsoft Office

• Online help for SAP Analytics Cloud, add-in for Microsoft Office
• SAP Analytics Cloud, add-in for Microsoft Office community topic page
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

excel cell reference issue, sac excel add-in, table2 formula error, external reference formula, add rows/columns, xlookup alternative, sap analytics cloud, table1 to table2 reference, formula not populating correctly, sac integration excel , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem