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.