DBRW Formulas Disappearing

[Jsanza]

Hi Guys,

Some of our users are experiencing a strange error when capturing values in cells containing DBRW formulas in Excel. When they capture a value in a cell and press Enter to submit, the DBRW formula disappears and get replaced by the value they entered. The value is not even getting updated in the cube cell to which the DBRW formula was linked. Please note, this is only affecting some users, not all.

Any help would be greatly appreciated.

Thanks!

[baggottm]

Perhaps you could give a more complete example, and that will help people to guide you.

[rmackenzie]

When they capture a value in a cell and press Enter to submit, the DBRW formula disappears and get replaced by the value they entered. The value is not even getting updated in the cube cell to which the DBRW formula was linked. Please note, this is only affecting some users, not all.

Perhaps it is worth checking if there is any Excel VBA capturing the Worksheet_Change event. Entering code in this sub-routine can upset the TM1 add-in code that updates the cube and controls the DBRW.

Also it may be worth checking out this technote in case the affected users are doing something related to this functionality.