Occasionally, even if a several cells contain the same data validation settings, you'll get a warning if you try to change the data validation in those cells
Problem reported in excel.misc newsgroup, by Kate, 2005-Mar-10.
Download the zipped sample file
Note: If you copy the group of cells to a different worksheet, the error message doesn't appear.
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: January 9, 2017 6:59 PM
Contextures RSS Feed