Hi all,

Just curious if others have found a way around the IMPORTRANGE error that occurs in Google Sheets? I have searched around & found that it's a known issue & the current fix is to simply change a cell reference from upper to lower case for example but looking for a full-time fix of any info as to why this happens & how to avoid it. Maybe even an alternate formula?

I use this formula in a number of sheets for a few different reasons but predominantly because,
  • I import large files (1 million cells & upward of data) & this formula allows me to select which columns to import to reduce the size of the sheet.
  • This formula also allows me to pull selected data form sheets that may contain sensitive data. I can pull the data I need without sharing all of the document

What I have found is, some sheets have been running for months & have never needed any attention while others have needed to be 'fixed' nearly every day. This can cause numerous issues as some of these sheets are shared on a national level to supply critical info to the business & other sheets are fully automated & as such, I do not check up on them that often & only find out if there is an error if someone lets me know.

Looking forward to hearing your thoughts.

Thanks,