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?
|