Active Form Formula Edit

hnhening

Has anyone ever seen behavior in an active form where when you go to edit the formula by pressing F2 or by editing the forumla directly excel does not recognize the formula and just displays the DBRW formula as text instead of recalcing the DBRW.

So for example if I had a DBRW in a cell that was displaying $100, I then edit the formula and instead of recalcing it says =DBRW(cube, Dim1, dim2, dim3), then when I press to rebuild the current sheet it changes the formula to something like this =DBRW(cube, RC2000, RC2010, RC2020), so no error just showing the text again.

315196952

It is a bit of an annoying one when this happens, you can solve it by:

[1] Edit format type in the cell to general (from text)
[2] Click in the formula bar and then press ENTER
[3] Rebuild the sheet

Also make sure that the formatting rows are set to general up the top.

HTH