I am trying to use data validation based on a text list over a large worksheet, however when copying past a certain point, the validation cannot be applied.
(error message: Excel could not save all the data and formatting you recently added ...)
The cells involved are every 2nd column between d15:fh28, and d30:fh42, d44:fh57, d73:fh86 etc down to d740:fh753.
Does anyone have a suggestion how I can overcome this limitation?