Skip to Content

Analysis for Office - Integrated Planning - Excel Formula


I use Analysis for Office (2.6) with an input ready Query. I have a reference value in Cell A1 and Cell B1 is my input ready cell. In B1 I enter an Excel formula, e.g. = A1*1.1

The result is ok and when I transfer or save data everything is fine. But when I simply "overwrite" the content of B1 (in the same session), and transfer data everything is calculated with the new value but after calculation the old value (from the formula) is shown in the cell, because the formula remains!

When I restart the workbook, the formula is gone and entering a new value is no problem.

Why does the formula remain even if I overwrite it with a "normal" value? As I don't want to use planning functions for such a calculation, I would like to know, how I can handle this scenario. In a standard Ecxel cell the formula is gone, if I enter a new value.

Best regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 21, 2018 at 01:20 PM

    Hi Gunter Cokl,

    i just tested your scenario, i also observed the same situation i believe this a bug

    you may raise an incident for this


    Add comment
    10|10000 characters needed characters exceeded