Ask Your Question
0

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

asked 2013-06-24 11:29:14 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 14:44:04.751295

Comments

OP: @GlebG

manj_k gravatar imagemanj_k ( 2014-02-16 23:44:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-01-16 04:27:08 +0200

m.a.riosv gravatar image

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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-06-24 11:29:14 +0200

Seen: 1,188 times

Last updated: Jan 16 '14