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.

  • 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. – Rubén Apr 27 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 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 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? – Rubén Apr 30 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 at 9:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.