Excel Add-in Error - Refresh failed. The required name range could not be found.

CallumW

Hi all,

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?

Best,

Callum

Accepted answers

All comments

anirudh

Hi Callum,

I have also experienced intermittent errors while using the Excel add-in. In the case of name range not found, just running a refresh again usually resolves the issue

CallumW

Hi Anirudh,

Unfortunately I cannot fix it in this way.

I am also unable to Pivot (the button becomes completely unresponsive for a period of time) - wasn't an issue on v3.0!

Best,

Callum

Quick Links

Can you help?

Unanswered questions

Update email id
Can anyone please explain how to update my registered email ID jn Anaplan.
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…