The approach I would take would be to create the pivot  table from rows  1 to,
say, 400. then when the pivot table  is refreshed it will take into account
any new rows added. It may have an entry for the blanks but generally that
does not matter.