Adhoc report - data validation drop down list everywhere
SummaryHow to turn off this data validation drop down list
Hi, when i create an adhoc report and start refreshing it, a lot of the cells will appear data validation drop down. Even for cells that are only to reflect data values. I have uploaded a picture of how it looks like.
I had to highlight the whole website to clear data validation. Even when I do it, the next time I refresh the sheet, it will appear again.
this is kind of annoying.
Is it some kind of smart view options that trigger this?