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