how to "really" lock pivot table selections?

[Bill-E-BoB]

I have a worksheet that gets added onto & modified each week with a VBA program I wrote, and the pivots are supposed to update automatically each time it does. The problem is this: The VBA script deletes certain rows from this sheet when they're completed, and adds new ones on as they come in. And when rows delete, the pivot tables change the size of their selection.

For example, if its set to use $A$20:$AC$5000 for its data, and then the macro deletes 100 rows for this week but adds 100 new ones, the pivot changes its selection to $A$20:$AC$4900 and I don't get pivot details on the last 100 orders until I manually update the pivot. Isn't there a way I can make it just stick to $A$20:$AC$5000? I would've figured the dollar signs would do it, but they don't.

[Bill-E-BoB]

Or if there's a way to just pivot the whole sheet from my headers down...sort of like using $A:$AC as the data, but starting on row 20 instead of all rows, that'd work fine too...

[VBA Noob]

This link may help

http://www.contextures.com/xlPivot01.html#Dynamic

VBA Noob