| 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) | |||
Hybrid Mode
