Spreadsheet A is the primary data source for a group that welcomes newcomers to our small town. It has a ton of very sensitive data and may not be publicly available, even a little. (We are talking about the names and dates of birth of the children and where they go to school ... Keeping the Table Safe is critical.)
So, table B uses importRange and a query to pull the necessary columns from table A to populate our "member directory".
Then I pinned table B in the Google Site group. (Feel free to check the site, if you want, at www.SewickleyNewcomers.com)
And it works great.
BUT., After I close spreadsheets A and B and follow for several hours, if I try to open a web page with an embedded member, the embedded sheet says "#VALUE!"
When I close Table B again, he says the same thing: "#VALUE!".
Suppose I let Spreadsheet B sit for a few minutes. Then, after he sat for several minutes, suddenly all the data is filled again.
And if I go back to a webpage with a member included in it, all is well.
Presumably, the problem is that if table B is not open, it cannot retrieve data from table A.
But I cannot insert table A, because there are columns and sheets that cannot be publicly accessible, as indicated above.
Some information:
A B ", " . ( , Spreadsheet A "Private".)
B Google Site " ".
, , A B:
= arrayformula (query (importrange ( "_", "Master! A: Z" ), " Col3, Col2, Col22, Col18, Col19, Col20, Col21, Col24, Col26 =" , . ' (Col4 =' ' Col4 =' ') Col3 "))
- , ? A (, , B, A )? , - Script Google , ?
! , , !