Excel addin api - How to improve data validation performance when large no of data inserted into validation

[arshadansari10]

I m assigning 100 no. of values as a data validation in each row to a specific column and this increases the performance load time. Is there a way to achieve efficiency in it

[peronald]

Thank you for this question. For programming questions, we suggest you go to Stack Overflow and see if your question has already been asked or ask a new question. This will allow both the community to help, and allow us to ensure the community can see our answer. When added, please let us know and we will follow up there. Thanks, Microsoft 365 Developer Platform team.

[microsoft-github-policy-service[bot]]

Thanks for your interest in Office Add-ins development! Feedback here is intended for reporting problems with the Office Add-ins documentation. Can you please post your question to Stack Overflow with the office-js tag? By posting how-to questions like this to Stack Overflow, you'll not only be able to reach a broader audience of folks who have expertise in the area, but will also enable others to benefit from any answers that are provided there. Thanks!