You don't need OFFSET or anything in XL2010.
Just declare your range as a table and use the table as source for the PT
It will include any rows added or removed automatically.
Of course the PT needs to be refreshed which can be done with some VBA eventually ( Google around for the code)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post