469,616 Members | 1,806 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,616 developers. It's quick & easy.

Data From Access Pivot In Excel

benchpolo
142 100+
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.
Nov 6 '07 #1
1 2339
MMcCarthy
14,534 Expert Mod 8TB
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)
Nov 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Charles Alexander | last post: by
1 post views Thread by John | last post: by
1 post views Thread by matthew kramer | last post: by
1 post views Thread by Grey | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.