Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent pivot tables / charts from editing | Excel Discussion (Misc queries) | |||
How to prevent the auto resizing of a column (ie, lock the width) | Excel Discussion (Misc queries) | |||
How do I prevent hidden rows from unhiding when resizing row ht? | Excel Discussion (Misc queries) | |||
Pivot Tables are Automatically refreshing | Excel Discussion (Misc queries) | |||
Column Resizing and Pivot Tables | Excel Discussion (Misc queries) |