title: How to debug #REF in Excel Index function
body: <p>I have two Excel Workbooks:</p>
  
  <ul>
  <li>Data.xlsx</li>
  <li>Report.xlsx</li>
  </ul>
  
  <p>I want to reference Data.xlsx from Report.xlsx and I reference using the following formula:</p>
  
  <pre><code>=INDEX('[Data.xlsx]Sheet1'!$A$7:$F$33,2,6)
  </code></pre>
  
  <p>It works fine. However if I try to reference the next cell I get a #REF error.</p>
  
  <pre><code>=INDEX('[Data.xlsx]Sheet1'!$A$7:$F$33,2,7)
  </code></pre>
  
  <p>It's behaving like I'm querying outside the bounds of the range.
  How can I debug this error?</p>