Prevent pivot tables from automatically resizing
 

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

Prevent pivot tables from automatically resizing
 

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

--
Regards
Roger Govier

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

Prevent pivot tables from automatically resizing
 

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


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


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Prevent pivot tables from automatically resizing
 

Doh!!!<bg

--
Regards
Roger Govier

"Debra Dalgleish" wrote in message
...
Right-click on a cell in the pivot table
Click on Table Options
Remove the check mark from AutoFormat table
Click OK


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


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com