Excel Add-in: refresh all connections in a workbook at once

It would be great if you could refresh all connections at once in one excel workbook. Currently, each sheet has to be done manually.

In some of our excels we use for reporting, I have 15-20 sheets as currently you can only have 1 connection / 1 sheet.

This would help a lot in efficiency.

Thanks

Kinga

Comments

philip.austin

Fully agree, this would greatly enhance the team's efficiency. 👍

MagaliP

Status changed to: Delivered

MagaliP

This is already possible, see how to refresh multiple connections in a workbook.

Did you mean updating the page selector for an entire workbook as opposed to for one sheet at a time? @kinga.markovics @philip.austin

kinga.markovics

@MagaliP , apologies, I didn't realize the muli connection refresh worked for this purpose. I've now used that to refresh multiple sheets in excel. Thanks!

philip.austin

Thanks @MagaliP and @kinga.markovics

MagaliP

Status changed to: Delivered

Quick Links

New ideas

Assistance Required for Understanding User License Roles at Tenant Level - Anaplan
Team - As per my understanding, user roles should work as described in the table below, but it is not working as expected. Our expectation is to assign users to a read-only role to restrict their access to a specific model, instead of creating user roles within the model. Any insights would be greatly appreciated. Thank…
Text input on total level
Dears, We would like you to enable text input on text summaries. Could you please consider adding “text input” button for text type summary method? This will help a lot for better navigation, for example when commenting data on total level like P&L total figures.
Ability to Generate Management Reports based on a Hierarchy Chart
We currently have a requirement, working with a very large Bank on their Workforce planning use-case to view their Organisational Hierarchy in a Current and Proposed state. The UX view of the Hierarchy Chart works well, even with very large volumes of data. There is also a requirement to have a Management Report that…