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

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…