Thread: Data Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Data Validation

click insertnamedefine and look where it is


--


Regards,


Peo Sjoblom


"sterling" wrote in message
...
I have a file that I am trying to change the defaulted Validation List in a
cell. When I choose from the menu, Data, Validation, the first tab has a
field of "source". There is a =ProbRating typed in this field. I assume
this is a list that was created, but I cannot find it anywhere in the
spreadsheet. How do I find and change the source of the "source"?
--
sterling