Data Validation

Copper Contributor

Hi All,


I have two main issues:

- I have a large amount of cells with a data validation dropdown which I think could be slowing down my sheet and causing it to "run out of resources."

- The data used in validation is constantly changing, the input data is relevant for multiple different workbooks used by numerous users. I want to ideally have a central store for the input data that I can update without having to go in to each workbook seperately.


Is there anything that can be reccomended to avoid the above problems? Either by improving how I am using data validation or an altogether different option.


0 Replies