On Sun, 13 Jan 2008 22:53:10 -0800 (PST), ravisagar
wrote:

Hi,

I have downloaded this extra functions package. I want to display
unique values in the drop down list. But when I use UNIQUEVALUES()
function in the data validation it gives me error "You may not use
references to other worksheets or workbooks for Data Validation
criteria."

Help!!


That is a limitation of both data validation as well as conditional formatting.

However, you can set up your list on your worksheet (in some hidden area,
perhaps), using the UNIQUEVALUES function, and then refer to that list as the
Source in your Data Validation settings.
--ron