Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Rows/ Pivot table
I use a pivot table for inventory transactions, and I'll have a column next
to the pivot that I use for analysis. However, when I add a new part to the database and refresh the pivot table, it naturally adds the new part and shifts the cells downward. But the column that I use for analysis doesn't shift down with it. Is there a way of locking rows in this instance? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking Rows/ Pivot table
Hi Jaye
You can't lock the rows in the way that you describe. The PT will grow or shrink according to the criteria set, and your extra data (being outside of the PT) will not be affected. You can ensure that the same data is being picked up each time though, by using the GetPivotData feature to select the cells for your supplementary analysis, rather than using things like =F6 where column F is the column with Grand Totals by row. Take a look at Debra Dalgleish's site for more help with the GetPivotData feature http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Jaye" wrote in message ... I use a pivot table for inventory transactions, and I'll have a column next to the pivot that I use for analysis. However, when I add a new part to the database and refresh the pivot table, it naturally adds the new part and shifts the cells downward. But the column that I use for analysis doesn't shift down with it. Is there a way of locking rows in this instance? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) |