How to embed Base query in Calc? (and have it remain connected to the query)


Is there a way of including Base query data in a Calc spreadsheet in a way that keeps the Calc spreadsheet updated everytime I modify the query?

I know how to drag query data (from Data sources) into my spreadsheet (see image) but then it’s fixed. It doesn’t seem connected any longer with the query. I want the calc data to update whenever I modify the query (or at least whenever I refresh the spreadsheet).

Many thanks,

The drag&drop operation establishes a linked database range. menu:Data>Refresh refreshes the database range.

[Tutorial] Using registered datasources in Calc

1 Like

Thank you. I hadn’t realised it was indeed linked. I’ve just tested it and it does update.