Excel Add-in Error - Refresh failed. The required name range could not be found.
I am getting the following error after trying to refresh data after connecting to a module through the excel add-in.
"Refresh failed. The required name range could not be found."
I am using V3.1 and have never had this issue before.
I have done some testing and it seems there is something wrong with the name of the module which is
|KPI's | Demise | KPI's|
After changing the name to ABC123 and reconnecting and refreshing there was no issue.
Is this a known issue?