Is there any way of automatic change in layout of pivot table according to data in columns ?

[#1]

I have tried using "auto Fir Columns to Data" but in our application we can't give 'edit and use these types of edit object properties ' rights to user.

Please suggest !

[trdandamudi]

As far as my knowledge, I don't think there is any other option...

[#3 · Accepted solution]

Thank You Thirumala. I have found its solution by hit and trail.The most appropriate solution to our application was to first change the pivot table into a general table and the increase the width of that particular column width to the widest length of data you may get. And it works .