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

[kinga.markovics]

Hi

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

[philip.austin]

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

[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