I have a pivot table that is set to refresh upon opening my file, and its data comes from the Power Pivot data model. The data model loads/refreshes upon opening the file as well (by default - I don't know if this can be changed). The problem is that the pivot table seems to refresh before its underlying data, so to have the latest data show in the pivot table, it has to be refreshed a second time. My pivot table is on a hidden worksheet the end user does not interact with, so I'd like to keep all the refreshing automatic.
Ideally the underlying data would refresh, and THEN the pivot table would refresh. Can I do make this happen?