Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot table overwrites neighbouring cells
Hello,
I have multiple pivot tables on the same sheet to allow for easy comparison of data. The source data is a web query that is based on weekly data. As the week progresses, the size of the pivot tables will increase and overwrite data below it. I am looking for a workaround or if there is a way to set the pivot table to insert a new row below it if the table size will increase. Thanks in advance! Anissa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Sums; Automating range changes in non-neighbouring cells | Excel Discussion (Misc queries) | |||
Pivot Table not populating cells | Charts and Charting in Excel | |||
Pivot Table Cells | Excel Discussion (Misc queries) | |||
Counting Non-Zero Cells in a Pivot Table | Excel Discussion (Misc queries) |