I am new to pivot tables..

  • Thread starter Thread starter jamiads
  • Start date Start date
J

jamiads

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??
 
jamiads said:
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??
Click to expand...

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.
 
There might be a more effective way of doing it. But if you click on the
pivot table, right click... go to PivotTable Wizard.

Then in the wizard click "back" once. Then change the last number there to a
very large number like 50,000.

Then on your pivot table just click on hiding blanks... and it will never
show up and you'll always be able to refresh.
 
Back
Top