Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
Hi @ANKITA SAHA ,
yes, you can use the suggested value feature in the excel add-in
Below that, you can see the option to apply validation rules as well.
Best, Helmut
Thanks for the answer. But how will a user maintain it? Is it a one time thing or is it something we need to configure everytime we export?
This configuration will be saved within the workbook. So, whenever the data view is exported to a (new) workbook, it needs to be configured again.