Multiple Sheet Add in Connection

Hi everyone, I have 2 questions about excel add in Refresh Multiple Connections function:

Does the refresh multiple connections functionality refresh only the dimension selected on the selector (for example July 23) of the module/excel sheet or all the data present in the module?

2. In case of many sheets connected to different Anaplan modules, it is possibile to set the selector dimension only one and then all selector of other sheets be automatically aligned? This would be helpful in case of many sheets to be refreshed at the same time, to be sure that the refresh is involving the same dimensions selected in every single sheet.

Hope the questions are clear. Thank you,

Joana

Accepted answers

All comments

Dikshant

#1 It refreshes for all dimensions. I would say to give it a try by changing the data for Jun23 and then refreshing it by selecting Jul23 in Excel, and then checking if Jun23 is refreshed or not?

#2 As per my understanding, selectors can't sync for multiple sheets. You have to set it sheet by sheet.

I don't use excel add-In very frequently, and this is as per my opinion, so I would say, give it a try and explore more.

MissSophie

@Tiny Fishing: this feature when you use refresh in excel, it will update all connections associated with that spreadsheet or module, fetching the latest data from Anaplan based on the basic connection settings. So it will usually refresh all data associated with the module, not just the data filtered or selected on the dimension picker.

Ethancarter

The Refresh Multiple Connections functionality in Excel typically refreshes all data present in the connected Anaplan module, not just the dimension selected in the selector (e.g., July 23 snow road). It ensures that the entire dataset is updated to reflect the latest information.

Quick Links

Can you help?

Unanswered questions

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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385