I have an Excel pivot table that references an Access table. Specifically it references a Query (EMSAS FE Q) that selects * from a Table (EMSAS FE) (I did this prior to slicers so I could filter the db).
I made a change to the Query on a field and then changed in back
ERRORS
1. "Reference is not Valid"
2. One or more connections didn't refresh or the refresh operation was cancelled. Would you like to refresh the remaining connections?
3. PivotTable report cannot overlap another PivotTable report.
After excel refreshes, My field named CALYEAR goes away and "EMSAS FE.CALYEAR" appears. With I attempt to filer on that file I get the error "This field has no item".
Any help would be greatly appreciated.
I made a change to the Query on a field and then changed in back
ERRORS
1. "Reference is not Valid"
2. One or more connections didn't refresh or the refresh operation was cancelled. Would you like to refresh the remaining connections?
3. PivotTable report cannot overlap another PivotTable report.
After excel refreshes, My field named CALYEAR goes away and "EMSAS FE.CALYEAR" appears. With I attempt to filer on that file I get the error "This field has no item".
Any help would be greatly appreciated.