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

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

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

6 Comments
philip.austin
Group Leader - Employee

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

MagaliP
Community Boss
 
Status changed to: Considered for Future Roadmap
MagaliP
Community Boss

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
Contributor

@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
Group Leader - Employee

Thanks @MagaliP  and @kinga.markovics 

MagaliP
Community Boss
 
Status changed to: Delivered