IMPORTRANGE is not updating on a my sheet. I've been using it on hundreds of other sheets with no update issues, but it is no longer functioning for me.The sheet is set to update every minuteI have tried the 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?Edit: This is not a duplicate. I have explicitly stated that:I have tried the now() trick
IMPORTRANGE() will not update unless deleted and re-pasted
google spreadsheets
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.