Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
IMPORTRANGE is not updating on one of my sheets. I've been using it on hundreds of other sheets with no update issues but it is no longer functioning for me.
now() trick to get it to update on a recalculationThe formula has to be removed then pasted back in for it to update. If I do an IMPORTRANGE from the sheet to itself, it will update as changes are made.
Any idea what is causing this, or how to fix it?
This was an issue with the sharing settings on the sheets.
It looks like a sheet that is set to Specific People in the sharing settings cannot be automatically imported into a second sheet. If you have access to the first sheet, you can set up an IMPORTRANGE, but it will not update.
The sharing permissions on the first sheet need to be set in such a way as it is always accessible by the 2nd sheet without violating any sharing permissions.
In my case, I set it to Anyone in my organization with a link.
It's not about the way you shared; it's about the locale that you use for each spreadsheet.
Go to File -> Spreadsheet Setting -> and make sure you have same Locale and Time zone for both Google sheets. The one you put your data and calculations, and the one you shared with the others, and you used importrange() on it.
I just ran into this same issue...we've never had an issue with importrange working across MANY sheets which are selectively shared, but today it randomly stopped working. I ran upon this article in my research.
Upon further investigation, I found that only one spreadsheet that was failing to export--the importrange functions on that sheet were still working just fine to pull data in from other places.
Just before it failed, I'd placed edit restrictions on a few columns to keep other users from deleting critical formulas. I went back and removed those restrictions, and the importrange worked just fine again.
So in a long, roundabout story...it appears that sharing with specific users doesn't create the issue, it's restricting users from part of the sheet. It could be just restricting the sheet in question, or it could include the whole workbook. I fixed my issue and haven't dug into it further.
I had the same problem and removed the sheet protection and it started updating.
The answer is quite simple. You need to use the URL link generated in the Sharing settings when creating your importrange() formula. You have to use the option "Anyone in my organization with a link". If you use the URL shown in your browser, the system may not see the importrange function call as having the correct permissions.
