I created a custom function on a Google Spreadsheet with the Google Scripts extension. The main idea is that this function connects to an external API to retrieve some company data, but this API has usage limits. The problem I'm having is that whenever I open the Spreadsheet, it tries to re-run the custom function for each of my listed companies. Is there any simple way to avoid this re-run? I'm thinking on checking the display value on the active cell and check whether or not it is empty or says "Loading...", but it does not seem too elegant.
Thanks!
Will try to check the value of the current cell but it does not seem as the best option
