Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Have you done Insert | Name | Define to see if it is listed there? If
it is, you can see what range it refers to in the bottom of the panel. Hope this helps. Pete On Nov 9, 11:04 pm, sterling wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |