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?