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
Comments
-
Fully agree, this would greatly enhance the team's efficiency. 👍
0 -
Status changed to: Delivered0
-
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
0 -
@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!
0 -
Thanks @MagaliP and @kinga.markovics
0 -
Status changed to: Delivered0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!