title: using indirect function in Excel
body: <p>I am using indirect function to create a link into another closed workbook. The objective is to retrieve the values without opening the workbook. I have used the following in one place which works. </p>
  
  <pre><code>=INDIRECT("[NVOL.xlsb]Sheet1!A"&amp;C6)
  </code></pre>
  
  <p>However, in another place in the same sheet, the following does not work (gives a #ref error)</p>
  
  <pre><code>=INDIRECT("[MTM.xlsb]Sorted!A"&amp;B6)
  </code></pre>
  
  <p>It appears <code>[NVOL.xlsb]</code> is taken as a substitute for the full path but the full path is not visible. I have two questions</p>
  
  <p>a) The path in the former case (NVOL) somehow vanished. How do I make it sure it is visible so that the path can be changed if necessary?</p>
  
  <p>b) How to make sure the MTM.xlsb is infact backed by a full path?</p>