data validation

  • Thread starter Thread starter b166er
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
problem data validation and copy/paste 2
conditional data validation 6
Data Validation - Complex Q 2
custom data validation on cells with data validation values 2
Another counting question! 4
Data validation 13
Multiple data validation criteria? 1

Back
Top