Pivot table as part of reporting

[jimrosser]

Hi all, I have a pivot table in the middle of my worksheet. With data above and below. Problem is when
you expand the data it keeps giving this error "Do you want to replace the contents of the destination cells"
Is there a way in vb to tell it to automatically add the rows that I need so the data below isn't lost?

[dilipandey]

Or you can have lot of rows / columns hidden after the pivot on bottom / right side which will avoid overwriting of data



Regards,
DILIPandey
<click on below * if this helps>

[camap97]

I got same problem with jimrosser.
Can anyone help me other solution for this?
Thanks in advance.