data validation

B

b166er

hi members,

i used data validation on my data consists of mor
than 6000 rows when i clicked on circle invalidation entries there wa
message(your worksheet contains more than 255 invalid cells.only th
first 255 cell will be marked) how can i increase that limit of 25
cells
 
J

JLatham

I doubt that you can change this. I searched around and cannot find a
reference to the limit. But 255 is a typical 8-bit counter limit and I
suspect that they are keeping count with an 8-bit counter.
 
Top