55

When I try to use "=" function in sheet 2 of Analysis and select value from Sheet 1,the result is displayed in sheet 1 instead of sheet2.

Please share more details, such as the version of Analysis Office, version of Excel, etc. Screen shots would help too. Thank you

formula-bug.pngDear Tammy,

Thank you .

SAP BO : 4.2(SP2)

Analysis Office version : 2.2.0.51997

when I use "=" formula in a cell in Sheet 2 of excel and select value from sheet 1,the output appears in sheet 1 not sheet 2.

Regards,

Ambi

Hi Ambi - you are on the first version of 2.2 which offered this feature for formulas, so there will be many "bugs". Would it be possible for you to upgrade to 2.4 or 2.5 (the latest releases) and their most up-to-date patches?

Tammy

Hi Tammy,

Thanks for the info.

We will update the Analysis Office.