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.

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

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