Issue with entering into empty cell (PAx 2.0)
-
- Posts: 13
- Joined: Thu Oct 11, 2018 10:11 pm
- OLAP Product: IBM Planning Analytics
- Version: 2.0
- Excel Version: 2013 32 bit
Issue with entering into empty cell (PAx 2.0)
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.
- Steve Rowe
- Site Admin
- Posts: 2415
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Issue with entering into empty cell (PAx 2.0)
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,
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,
Technical Director
www.infocat.co.uk
www.infocat.co.uk