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.
Thanks,
