IMPORTRANGE Broken
EDIT: the problem resolved itself. Not sure if it was because I opened the dashboard on mobile, if google fixed a bug, or it was a fluke - but it seems to be working now. some great troubleshooting tips in the comments below if you come across this post experiencing similar issues.
Anyone having issues with IMPORTRANGE this week? I have a dashboard sheet that pulls some data from 4 other identically structured sheets owned by 4 other users. It's worked flawlessly for more than a year. Just this week I noticed one source giving the #REF! Import Range internal error. message. When I make a change to any of the source sheets, then the IMPORTRANGE on the dashboard breaks. If I view the version history of the source sheets, the current version says "Google Docs encountered an error. Please try reloading this page, or coming back to it in a few minutes." If I revert the sheet to a previous version then the IMPORTRANGE works, but if I change even one cell on the source sheet, the dashboard breaks again. I've tried reverting all the sheets including the dashboard to previous versions, and it works until I make any change.
As a random test, I created a brand new sheet with my personal account, created an import range reference to another brand new sheet with my personal account, and it works - until I refresh and then it breaks there too. so it doesn't seem to be related to permissions, my account, my browser (tried 3 different PCs), or the sheets themselves. is google sheets having some heartburn this week?
Posted Jul 21, 2022, 4:20 PM UTC · edited