Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When I use pivot table to display long text, the mouse over text will be chop off at around 500 char in IE.
In order to overcome this, I increace the value for "Wrap Cell Text" to a bigger number, but this causes all the other cell height to expand also.
And this caused the data in the pivot table to be hard to read and scroll.
Is there any way to make the pivot table behave like the table in MS Excel where the cell height is adjusted automactically?
Unfortunately no, at least as far as I know.
You either have the 1 line cell heightor a set cell height which applies across the board.
Unfortunately no, at least as far as I know.
You either have the 1 line cell heightor a set cell height which applies across the board.