title: Indirect reference not working excel 2010
body: <p>Im trying to create a reference using the indirect formula in excel 2010 however the reference doesn't seem to return any results.</p>
  
  <pre><code>     =D53+INDIRECT("'01 07'!"&amp;I53)
  </code></pre>
  
  <p>If i use the reference in a different way it works.</p>
  
  <pre><code>     =D53 + '01 07'!I53
  </code></pre>
  
  <p>Can't seem to figure out what the problem is. In the future i need the indirect formula to reference to the current sheetname.</p>
  
  <p>Thanks in advance !</p>