What formulas are needed and how to do it?

P

Pusont2019-07-04 16:03:54

excel

Pusont, 2019-07-04 16:03:54

Made transfer from several tables in one the general formula (IMPORTRANGE). How to make sure that data from those Google tables is transferred automatically so that corrections, data changes, and so on are visible in the general one.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Ivanov, 2019-09-08
@oshliaer

The formula IMPORTRANGEperiodically makes a request to the source to update the data. It is not possible to speed up this process.
Alternative means are Google Apps Script, the use of the Google Sheets API, or third party software.