Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm using the importrange() function in Google Sheets to reference data from 'spreadsheet1' and display in it 'spreadsheet2'.

This works fine, but if I edit 'spreadsheet1' and then go to 'spreadsheet2' it's not automatically updated, nor does it update if I refresh the page. I've set my cache to be limited to 0MB so it shouldn't be saving anything locally.

Any ideas how I can get it to check back the its master spreadsheet more often and update its values accordingly?

share|improve this question
Read the following URL:!topic/docs/BsOdrVdZYdI –  Jacob Jan Tuinstra Apr 16 '13 at 10:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.