jamiads wrote:
I have created a database of purchase orders. I have my table set up to show
gross margins etc per salesperson. I add once a week to my database. After
adding this weeks data when I hit 'refresh data' the total do not change.
Why??

If you are adding data at the bottom of your list, then you need to adjust the
range that the Pivot Table is based upon. Click on your Pivot Table and then
select "Pivot Table Wizard". Click "Back" and adjust the source range.