Prevent pivot tables from automatically resizing

N

Neilct

I'm using Excel 2003 and would like to know how to prevent pivot tables from
automatically resizing when a new selection is made.
 
R

Roger Govier

Hi
Can you explain in more detail what you mean by this.
What new selection? adding more rows to the source table?
 
D

Debra Dalgleish

Right-click on a cell in the pivot table
Click on Table Options
Remove the check mark from AutoFormat table
Click OK
 
Top