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?
Delay in updating referenced cells when using importrange in Google Sheets
google spreadsheets