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

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