Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables Overtaking Non-Pivot Rows
Hi All,
I am trying to format a pivot table so that it doesn't overtake and delete any information contained in cells that are below it. When I refresh my table's data, it sometimes becomes longer than it was originally formatted to be, and it deletes the information in the cells below it; it sort of looks like this, before and after: Before Refresh: _______________________________________ | Group 1 Group 2 Group 3| |Item 1 blah blah blah | <---Pivot Table |Item 2 blah blah blah | |______________________________________| CellInfo1 CellInfo2 CellInfo3 CellInfo4 <---Cells with Non-Pivot Values After Refresh: _______________________________________ | Group 1 Group 2 Group 3| |Item 1 blah blah blah | <---Pivot Table |Item 2 blah blah blah | |Item 3 blah blah blah | |Item 4 blah blah blah | <---Where Non-Pivot Values Were |______________________________________| Notice how the cells below it are now gone. Is there some sort of simple solution to this problem, or will it involve a more complex VBA work-around? If it does require some VBA, would anyone be able to provide me with a sample of code that may work for my situation? I would greatly appreciate any help! Thanks in advance!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a column of comments "with" pivot table as pivot tables datachanges, causing rows to be added and deleted. | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
(Tom?) Pivot tables, code to refer to all pivot tables on template | Excel Programming | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |