I have a pivot table that users enter data outside the table that is
associated to data inside the table i.e. due dates are entered by users for
part numbers inside the table. The table needs to auto re-fresh and needs to
be sortable by data inside the table so when this is done I lose the
association to the data outside the table.