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 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.

Take a look at these:
http://www.contextures.com/xlPivot02.html

http://peltiertech.com/Excel/Pivots/pivottables.htm



Regards,
Ryan---

--
RyGuy


"Glenn" wrote:

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.

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.

"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??

akphidelt wrote:
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.

Best idea I've used is to set the pivot table's data range to full columns.

And hide blank categories.

Never another worry about missing added data.