In the Browser View Options Parameters in Excel, why can't we select a desired named field when we click Add?

enter image description here


The reason was that:

  • Formulas aren't supported in the named value
  • Data validation isn't supported in the named value

See more info here: https://support.office.com/en-us/article/Change-workbook-parameters-in-Excel-Services-5e6f3c25-4d58-4040-931a-c769dddd62df

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.