I have an Excel workbook that links into an Access database. It has three
pivot tables linked into the data that refer to a named range that changes
with the amount of data.

I have it set to refresh the data and the pivot tables when the workbook is
opened, but it seams to update the tables then the data.

How can I make it update the data then the tables?