title: How to avoid "Loading..." message/ flash in Google Sheets?
body: <p>Is there a way to disable the <code>Loading...</code> message that appears in Google Sheets when calculations are being made? </p>
  
  <p>If there's not a way to disable it, is there a way to <em>trick</em> it? In other words, let the calculations be determined in a hidden row and <code>import</code> them into a cell when finished?</p>
  
  <p>The reason the <code>Loading...</code> is taking so long is due to a custom script that does a <code>=count</code> on every cell specified within the range when a change has been made to a cells <strong>background color</strong>. </p>
  
  <pre><code>.                                
  .                             &lt;color&gt;      &lt;range&gt;   &lt;key&gt;  &lt;range&gt; ← (auto refresh cell)              
  .                                ▼            ▼        ▼       ▼
  =countWhereBackgroundColorIs("#e9f7fe", "$G175:$BN264","",$G175:$BN264)
  .
  .
  .
  </code></pre>
  
  <p>It's super handy, but w/ this comes the performance hit.</p>
  
  <p>Anyone have any pointers?</p>
  
  <hr>
  
  <p><strong>Here's a video of the problem in action:</strong> <a href="https://drive.google.com/file/d/0ByR1kQvOUDJbWkFqUTlEWl9hakk/view" rel="nofollow noreferrer">Google Sheets "Loading..." problem</a></p>
  
  <p><a href="https://drive.google.com/file/d/0ByR1kQvOUDJbWkFqUTlEWl9hakk/view" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2cN18.png" alt="Disable Google Sheets &quot;Loading...&quot; message"></a></p>