I have an Excel workbook with a data table on worksheet A and a pivot table based on that table on worksheet B. The data table's source is an Access query. This all works great. Save, reopens, refreshes the data -- all good.
Now I create a new worksheet (C) and add a different data table from a different Access query. Works great. Saves, reopens, refreshes the data -- all good.
Then I add another worksheet (D) and build a pivot table based on the table on worksheet C.
Everything looks fine. I save and close the workbook.
When I reopen it, the data on C table is fine, but the pivot table on D is EMPTY. The PivotTable Fields shows Column1, Column2, ... not the columns in table C.
I've been working on this for HOURS. I've created a dozen new workbooks and rebuilt everything. Worksheets A, B and C are fine, but the pivot table on D keeps reverting to blank. What the heck could I be doing wrong?