Showing results for 
Search instead for 
Did you mean: 

BPC10 cell formulas clearing

Former Member
0 Kudos

Hi All,

wonder if anyone call help me with the following problem, any help is appreciated!!

I am working on an report within BPC 10. This excel report has numerous reports BPC reports within. I have cells within the excel spreadsheet that contain calculations on the cells from the BPC reports, when I refresh the data and select a different time range from the column axis (time is the column axis selection from the context menu) the sheet refreshes and all the native excel calculations are removed. I have checked the box in the sheet options to u2018keep the formula on datau2019. However all the cells with native excel calculations are still cleared, the BPC data displays correctly and the format of inserted rows is retained.

BPC version 10.0.0, windows 7, excel 2007 sp2.

Many thanks


Accepted Solutions (0)

Answers (1)

Answers (1)

Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Dave,

What version of the EPM Add-In are you using?

The latest available is SP05 Patch 1 (