Hi all.
I have a workbook that gets data from two different tables in an Access database, tblA and tblB. In Excel I have assigned a Table Name to each, TableA and TableB. Each is on a separate tab. Works great.
I have created several pivot tables from the data in TableA. Works great.
When I add a tab and create a pivot table based on TableB, it all looks fine until I close the worksheet and go back to it later. The pivot tables based on TableA are all fine. The columns and data in TableB all looks fine, but the pivot table based on TableB is empty, the PivotTable Fields show as Column1, Column2, Column3, etc, instead of the column names in TableB and they're not connected to the data in TableB. If I try to then create another pivot table from TableB, all the PivotTable Fields show as Column1, Column2, etc instead of the column names in TableB.
This is driving me crazy. I've tried both Excel 2013 and Excel 2016.
Any ideas?
I have a workbook that gets data from two different tables in an Access database, tblA and tblB. In Excel I have assigned a Table Name to each, TableA and TableB. Each is on a separate tab. Works great.
I have created several pivot tables from the data in TableA. Works great.
When I add a tab and create a pivot table based on TableB, it all looks fine until I close the worksheet and go back to it later. The pivot tables based on TableA are all fine. The columns and data in TableB all looks fine, but the pivot table based on TableB is empty, the PivotTable Fields show as Column1, Column2, Column3, etc, instead of the column names in TableB and they're not connected to the data in TableB. If I try to then create another pivot table from TableB, all the PivotTable Fields show as Column1, Column2, etc instead of the column names in TableB.
This is driving me crazy. I've tried both Excel 2013 and Excel 2016.
Any ideas?
