Im using the
importrange() function in Google drive to reference data from 'spreadsheet1' and display in it 'spreadsheet2'.
This works fine, but 'spreadsheet1' and then go to 'spreadsheet2' its not automatically updated, nor does it update if i refresh the page. Ive 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 ?