IMPORTRANGE function not refreshing new entries in linked Google sheet

google-apps-script google-sheets google-forms importrange
kjexley picture kjexley · Sep 22, 2014 · Viewed 18.6k times · Source

My IMPORTRANGE function is not refreshing with new data once the linked spreadsheet is added to. Instead, I am having to cut and paste all of the formulae again whenever I want to view the new information.

I'm using the new version of Google Sheets and I know there were some issues around the release of this with the IMPORTRANGE function.

I currently have 24 columns of data that I'm importing and the original spreadsheet will just keep growing as it is linked to a form. This is the main reason I'm using IMPORTRANGE, as it will help to keep the original spreadsheet working at maximum speed.

What I'd like to know is, has anyone else had a problem such as this, and if so is there any work around (in apps script/another function)? In worst case scenario, is there an apps script about which would clear the spreadsheet and re-enter all of the formulae on open/on a menu click as it really is a pain updating every column every time a new entry is made.

EDIT - Almost all of the cells I'm trying to import are formulated within the original spreadsheet if that changes anything - EDIT

Answer

Tim picture Tim · Jan 2, 2017

What solves the problem? Setting the same owner for both spreadsheets: the one that you import data from and the one where you use importrange formula. I had the same problem. I updated the source and no response on final spreadsheet. After setting same owner for both spreadsheets refreshing takes few seconds

Related questions

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question will be 'prefilled' with …

Read More
Retrieve the e-mail address of a Google Form respondent without asking for their e-mail address in the form

The scenario goes: Via email, a Google Form is sent to a respondent. Via this sent email, the respondent answers the form and sends their response. This form has no email address field. I need to retrieve the respondents e-mail …

Read More
Hidden field in a Google Form

I am adding a unique ID to each submission of the form. Right now, I made that ID the first field, and pre-filled it with the ID, along with a help text asking the user not to modify this field. …

Read More