Refresh all data imports from a DB query in spreadsheet at once

Hi there,

I have a spreadsheet which has some cells containing a data import from queries against a database. Now if I want to refresh the cell with with the latest value from the database I select the cell and click on Data/Refresh Range, which works fine. However, I cannot find a way to refresh all data imports at once. Hence, I would need to go through every cell, select it and refresh it with the latest value from the database.

Any help is appreciated.

Kind regards,

OP: @GlebG

In this thread you can find the code of a macro, what you can assign to a button.