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

[GlebG]

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,
Gleb

[manj_k]

OP: @GlebG

[mariosv]

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

http://www.oooforum.org/forum/viewtopic.phtml?t=100239