I have a table, A1:F100, and I also have a pivot table on the same page. When I insert a new row at the top of the table, it pushes everything including the pivot table down. Is there any method of locking that pivot table from moving down as well? Above the pivot table are six hyperlinks that I would like to lock their location too.