Hi,
I am unable to refresh my pivot table out of the sudden. Following is the error message I have encountered.
Noticed that "ThisWorkbookDataModel" is missing from existing connections as shown below.
Noticed this is how existing connections should look like for normal working file.
Have tried adding the data model back via the following steps, however to no avail. Still encounter same error message.
Data-> From Text-> Select "Only Create Connection"
I am using excel 2016. Appreciate any advice which can allow me to add back the data model or any solution to refresh the pivot tables.
I am unable to refresh my pivot table out of the sudden. Following is the error message I have encountered.
Noticed that "ThisWorkbookDataModel" is missing from existing connections as shown below.
Noticed this is how existing connections should look like for normal working file.
Have tried adding the data model back via the following steps, however to no avail. Still encounter same error message.
Data-> From Text-> Select "Only Create Connection"
I am using excel 2016. Appreciate any advice which can allow me to add back the data model or any solution to refresh the pivot tables.