Most Pivot Table Fields Disappear on Refresh/Refresh All
I have created a dashboard from pivot tables of demo data on COVID-19. Initially the pivot tables were from solely created from one data sheet but later other pivot tables (and charts) needed data from a second sheet. Excel created a Data Model to do this (have pivot tables from different source sheets). Now, when the data is refreshed, for one table or using refresh all, most of the fields for the numerous pivot tables disappear. (There doesn’t seem to be any pattern to the field/tables that remain.)
How do I stop this (the fields disappearing) from happening?
Note:
- “Autofit columns on update” has been disabled.
- The images below are quick snips from Before and After refreshing.
Before:
Before:
After:
After:
