'Google Sheet - Force a linked spreadsheet to refresh
I'm pulling a realtime quote from "spreadsheet B" into "spreadsheet A" through:
=IMPORTRANGE("url";"A1").
For some kind of reason the referenced cell in "spreadsheet A" is blank until I open "spreadsheet B". This will kickstart the realtime quotes and they will be updated also in "spreadsheet A".
It's worth mentioning that "spreadsheet B" is using a custom "apps script" in order to pull in those realtime cryptocurrency quotes.
Is there a way to have the calculations in "spreadsheet B" kickstarted only by accessing "spreadsheet A"? Thanks all!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|