title: #REF, #NAME errors in Getpivotdata Formula
body: <p>While trying to get data from a Pivot table using formula,</p>
  
  <pre><code>=GETPIVOTDATA(A4:F12,$A$4,"Severity",$A$23,"Current Status",$C$20)
  </code></pre>
  
  <p>This code gives me a "#REF" Error and</p>
  
  <pre><code>=GETPIVOTDATA(Count of Issue Number,PivotTable1,"Severity",$A$23,"Current Status",$C$20)
  </code></pre>
  
  <p>This one gives a "#NAME" Error. What should I do?</p>