Pivot Table in Place of Data Validation

[rkreuz]

I'm trying to create a table with drop down options for each cell (a different set of options for each column). Normally I'd use data validation, but I need to use Excel Services with this document, and that doesn't support data validation. I've seen mentions of using pivot tables to accomplish the same thing, but I can't find an example that works for my situation. I have eight or so column headers, and need a fairly large number of rows, all with the dropdown option. Is there a way to do this?

[oeldere]

In the link below you find a code and an example.

http://www.excelforum.com/excel-form...onditions.html

[rkreuz]

Excel Services (or at least SharePoint, which is what I'm using) doesn't allow VBA code in the document either. I should have specified that; thank you for your response.