0

On page 1 of my spreadsheet I have a bunch of Google Finance functions to retrieve historical data of various scrips. On page 2 I have some calculations running based on the historical data and on page 3 I have lot more calculations being done based on the calculations on page 2.

Every time I open this document it takes considerable time to update all the three sheets because of the interlinking. Can I program a sequence in which the sheets auto update on first open? What I'm looking for is a delay to allow the Google Finance equations on page 1 be fist updated and then page 2 followed by page 3.

5
  • Welcome to Web Applications . Short answer Yes by using an installable trigger and avoiding the use of custom functions. If you need further help please add more details. Apr 27, 2021 at 13:21
  • @Rubén thanks for response, will try the trigger function and if I still have difficulties will reach out.
    – Rajesh
    Apr 28, 2021 at 4:05
  • @Rubén "Yes by using an installable trigger" I struggled to think of a solution to this question, and I freely admit that I don't understand how a trigger could affect the recalculation order. Is this the kind of logic that you are applying Recalculate google sheet on demand?
    – Tedinoz
    Apr 29, 2021 at 23:11
  • @Tedinoz Let's focus on this question. I'm assuming that the OP is using custom functions, there is no way to prevent that custom functions be calculated when a spreadsheet is opened. Are you assuming the same and do you agree that custom functions always are calculated when the spreadsheet is opened? Apr 30, 2021 at 2:15
  • @Rubén I not assuming that there are custom functions. OTOH, I have it on the highest authority ;) that custom functions are recalculated on opening the spreadsheet.
    – Tedinoz
    May 3, 2021 at 9:01

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.