TM1 Forum

Has anyone experienced an issue with PAx where you enter a value or text into an empty cell and it automatically overwrites it with a DBRW formula? If I enter a formulas in the cell this does not happen. I'm trying to determine what exactly is causing this, but it only seems to happen sometimes. If I close Excel and re-open the file, the issue does not persist. I can't figure out if this behaviour is intentional or a bug in the software.

Yup, not sure if it is a feature or a bug either, certainly its annoying.

Our experience is that it only happens if you start with a slice / DBRW, remove some cells to do some pure excel work and then PAx adds back the DBRW. I assume its an attempt to provide some protection from users deleting formula in error.

Can't find anything documented about this or how to turn it off.

Cheers,