• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivote table Row height

D

delta

Member
i use 2007
when i create pivot table in pivot table set whole sheet row height is 30 but when refresh pivot table the row height in pivot table set is 15 why .
 
Hi ..

Try this..

Right click on the Pivot table.. and select Pivot Table Option..

02-03-2014 12-57-32.png

Uncheck "Autofit Column Width on Update"
 
Hi ,

Can you see if the problem still persists ? What I have done is copied the raw data sheets to a new workbook , and created the pivot table afresh in the new workbook.

Narayan
 

Attachments

Hi ,

I have already posted what I did ; all I have done is copy the raw data to a new workbook , and recreate the pivot table there. Can you confirm whether you still have the problem or not ?

Narayan
 
yes i have problem face to row height set. when i increase font size then row height auto set 15.
 
Last edited:
delta said:
when i create pivot table in pivot table set whole sheet row height is 30 but when refresh pivot table the row height in pivot table set is 15 why .
Click to expand...

let me try to understand your problem..

In Pivot Table Source Sheet (Sheet "Entry").. you have set ROW height as 30.
When you refresh Pivot Table in Sheet "Sheet 1", its displaying ROW height as 15.. which one.. you have never set.
You want to set the sheet with the PIVOT table, all row's height should me same as Source Sheet's Row Height..

Is this what you want.. !!!!
 
Narayan i face again problem for row height in pivot tabel i another new sheet was attached tell me what i can i do
 

Attachments

i check your file but whenever increase the font size in pivot table then row height is set 15. why what i can do
 
yes when i do not increase the font size the row height is set 30 but when increase the font size the row height is change.
 
You must log in or register to reply here.
Back
Top