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.
- The sheet is set to update every minute
- I have tried the
now()trick to get it to update on a recalculation
The 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?