Saving Workbooks without EPM Functionality

[Former Member]

Hi experts,

it is possible to save Workbooks from BPC into local folder without EPM functionality and formulars?

I have the need to store the report on a server root path and open that without any connection to BPC. In case that you save the Workbook via "save as" the Worksheets brings in every "EPM-cell" an error because of the missing connection to BPC when you will open the workbook after that.

The copy and paste "values only" function of Excel isn't useable because of sheet protection. 

Many thanks in advanced.

Matthias

[Astha_M · Accepted solution]

Hi Matthias,

You can try using Offline mode functionality provided in BPC.

First take the workbook offline and then save it in the local folder.

Hope it helps

Regards,

Astha

[Former Member]

Hi,

thank you it works great.

Regards,

Matthias

[former_member186338]

Hi Matthias,

In addition to Offline mode look also on a User options -> Others -> Protect Only Sheets Containing EPM Reports -> Static Offline Without Protection

It will create a copy of the sheet without any EPM formulas. Useful for presentation only!

Vadim