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.
Active Form Formula Edit
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Active Form Formula Edit
It is a bit of an annoying one when this happens, you can solve it by:
HTH
- [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
HTH
Declan Rodger