Hello. I have created a pivot table using data in another excel sheet. The original data sheet contains text cells with long text. In the pivot table, only part of the text is displayed in the each cell, the rest of the text can be seen when hoovering over it with a mouse. But it is not visible at the cell itself. Have you encountered this issue? Any idea how to solve it?
@Sergei Baklan - you may be onto something here. My cells have up to 2 000 characters and only the initial couple hundred get shown. Is there any way to get past those 256 characters and increase it to 2000?