Copy paste formula from excel into Anaplan blueprint

Options
LouiseBourgonjon
LouiseBourgonjon
in Modeling

Hi Anaplan community,

I wanted to make a quick fix to existing formula in my Anaplan blueprint view, so I exported my blueprint view to Excel, used the find&replace functionality in excel to update all my formula at once, and then I wanted to paste back my formula in Anaplan blueprint view, but it gives me this error message: "23 cell changes are invalid" when I select all my 23 cells at once.

It only works when I select the text in the formula bar in Excel for a single cell and then paste into Anaplan blueprint view (which is time-consuming as I need to do this one by one instead of in one go).

I think this has to do with the ' in front of the name of my modules, which is somehow disregarded when copy-pasting from multiple cells in Excel into Anaplan and therefore making my Anaplan formula invalid.

How can I solve this? I already tried changing the format of my Excel cell from general to text, but that did not help.

Thanks for any suggestions!

how to keep my formula format when pasting from anaplan to excel.png

Tagged:

Best Answers

  • KirillKuznetsov
    KirillKuznetsov
    Answer ✓
    Options

    @LouiseBourgonjon

    You can add one more ' sign in front of the formula where it is disregarded. This helped me every time.

    (you can write a formula to automate this bit in excel)

  • LouiseBourgonjon
    LouiseBourgonjon
    Answer ✓
    Options

    hi @KirillKuznetsov ,

    thanks for your reply. So I used the concatenate formula to add a ' in front of the formula and put the cell format to general and that works.

    Thanks

Categories