I have a form setup as a pivot table for specific items in the source data.
Everytime there is a new item added to the source data, the pivot table will
automatically select and show the new item at the bottom of the table when I
refresh the data. Is there a way I could keep the same format (i.e. the same
item displayed in the form) no matter if there is a new item added to the
source?