title: sheets giving importrange internal error but loads data on formula refresh
body: <p>we have several sheets that rely on <code>importrange</code> to get data from other google sheets, beginning this week we have had trouble getting some of them to load, we just get #ref import range internal error. </p>
  
  <p>I have tried a wide variety of solutions but all of them seem to only work temporarily whereupon refreshing the query it will sometimes manage to get the data, the size of the range is not the problem since the problem happens in large imports as well as imports that only get 1 cell. </p>
  
  <p>so far the best solution I have is deleting the <strong><code>=</code></strong> from the formula and then adding it back to force the data to load again however this only lasts for around 30 min before the <code>importrange</code> goes back to giving the same error.</p>
  
  <p>the formulas aren't anything fancy    </p>
  
  <pre><code>=IMPORTRANGE("sheet url","Update_Guide!b2:n2")
  </code></pre>
  
  <p>I have tried variations of capital letters for the ranges, as well as adding if error to try and load a variation of the formula</p>
  
  <pre><code>=iferror(IMPORTRANGE("sheet url","Update_Guide!b2:n2"),
           IMPORTRANGE("sheet url","Update_Guide!B2:N2"))
  </code></pre>
  
  <p>but nothing seems to work, or when it works the solution doesn't seem to stick.</p>
  
  <p>any help or insight into what may be causing this problem would be greatly appreciated.</p>