Data validation format in Cells not used
SummaryData validation format in Cells not used
I am using excel 2106 and smart view version 710. I notice that when I built essbase ad hoc report using smart view, some of the cells get formated with data validation list drop down, even though I pull the dimensions to columns and rows from POV.
I checked my smart view options and I could not see anything that can disable such auto format of data validation list on the cells.
I tried to clear all the data validation list format from the cells but it will come back after every refresh.