dropdown list in an excel web page

[Lourens Pentz]

Hi, can someone help me please? In Excel 2002 or Excel 2003 - I tried
in vain making a list, dropdown, or validation list that will show the
list values once I save the spreadsheet out as a web page? Is this
possible to do?
Any help will be much appreciated.
Thanks Ottolien

 

[Jim Rech]

When you display a spreadsheet created in Excel on a web page you are using
the MS Spreadsheet Component, not Excel. You are limited to the SS
Component's feature set rather than Excel's and the SS Component is very
limited in comparison. It doesn't support either validation or on-sheet
controls I'm afraid.

--
Jim Rech
Excel MVP
| Hi, can someone help me please? In Excel 2002 or Excel 2003 - I tried
| in vain making a list, dropdown, or validation list that will show the
| list values once I save the spreadsheet out as a web page? Is this
| possible to do?
| Any help will be much appreciated.
| Thanks Ottolien