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

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
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,446
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,497
Members
412,670
Latest member
Khin Zaw Htwe
Top