Data From Access Pivot In Excel

[benchpolo]

I have data extracted from Access db to Excel with a pivot table. Somehow, I am having issues with the pivot table were it doesnt update the totals. For example, the first extract i did in Access has 6000 data rows and pivot table in excel should refresh on open and reflect the 6000 data rows.

2nd extract in Access has 10000 data rows when pivot table opens it doesn't refresh the summary count on the pivot table based on the 10000 data rows.

Am I missing a step? Please assist. Thanks.

[MMcCarthy]

I have data extracted from Access db to Excel with a pivot table. Somehow, I am having issues with the pivot table were it doesnt update the totals. For example, the first extract i did in Access has 6000 data rows and pivot table in excel should refresh on open and reflect the 6000 data rows.

2nd extract in Access has 10000 data rows when pivot table opens it doesn't refresh the summary count on the pivot table based on the 10000 data rows.

Am I missing a step? Please assist. Thanks.

Your pivot table must be based on the 6,000 rows of the original setup. You will need to change the source (e.g. from A1:G6000 to A:G)