Save planning data keeping formulas

[Former Member]

Hi Experts,

I'm a new Analysis for Office user.

I'm saving plan data with a template linked to another cell. Whenever it gets saved, the link is broken and the formula is converted to the number that i've saved.

Is it possible to save the planning data maintaining the excel formulas?

I used to work with a similar tool, Oracle Smartview, and this was possible.

I've searched for an example where someone uses a formula linked to a cell to plan data, but i haven't find none.

Can you help me on this?

Thank you,

Rodrigo Mourinho

[TammyPowlas · Accepted solution]

I am not familiar with Planning, but last week at SAP TechEd SAP did show a demo where custom Excel formulas are saved - this is planned for Analysis for Office 2.2 (subject to change, of course)

[Former Member · Accepted solution]

Thank you for your reply, Tammy.

Best Regards,

Rodrigo Mourinho