SAP Knowledge Base Article - Preview

2983082 - It is not possible to use absolute cell reference inside the crosstab in Analysis Office

Symptom

In Analysis Office, when trying to set an absolute cell reference in a formula using the F4 key, the reference is converted back to relative.

For example: $B$4 will turn into B4 after pressing "Enter" or after leaving the cell.


Read more...

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Product

SAP Analysis for Microsoft Office all versions

Keywords

Absolute reference, F4 formula cells, formula cells, formula converter, new line, dollar sign , KBA , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.