title: Error in excel 2016 when adding a formula
body: <p>I have an Excel formula that works fine in excel 2003 but in Excel 2016 I get the error when clicking on Data Validation. </p>
  
  <p><strong>"You may not use reference operators (such as unions, intersections, and ranges) or array constants for Data Validation criteria"</strong></p>
  
  <p>My formula is</p>
  
  <p>=INDIRECT("IQ!"&amp;LEFT($T28, 2)&amp;"11"):INDIRECT("IQ!"&amp;LEFT($T28, 2)&amp;11+$V28)</p>
  
  <p>I had to do the formula like this, as the business users cannot update the formula themselves.
  I have a dropdown list in another sheet within Excel, which this refers to.</p>