Pivot Table Report - Won't Update

jherbst

New Member
Joined
Apr 27, 2005
Messages
2
I created several pivot table reports, based on a linked Access table. The original Access table had several hundred records with null values in one of the data fields.

I eleminated these records from the Access table and created the pivot table reports.

I have since updated the Access table to correct the records with null values, which in turn added the appropriate number of records to the Access table.

However, when I update the pivot table, these records do not appear. If I create a new pivot report, the records show up. The reports are fairly complex and I would perfer to not recreate the entire set of reports.

I am sure there is some way of correcting this issue, but I can't figure it out. Any help would be greatly appreciated.

Thanks... :(
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,447
I'm guessing here that you need to reselect the range that the pivot table is using. From the pivot table wizard, select "back" to take you to the range selection box.

I'm assuming this is the same as a normal excel file even though you have it linked to an Access table. (if not sorry)
 

jherbst

New Member
Joined
Apr 27, 2005
Messages
2
I appreciate your response, but...

It seems that when you link the pivot report to an Access table it grabs the entire table. You don't really select the range the way you would if you were creating the report from data contianed in an Excel worksheet.

Again, I appreciate you response...
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,447
I haven't done this myself, but had a quick look and is it not just the same but you have to go back through the "get data" stage to link to the table in question.

Can anyone else confirm?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,501
Messages
5,832,079
Members
430,110
Latest member
Chyke_mxl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top