Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,570
    Thanks
    44
    Thanked 73 Times in 69 Posts
    Unless I missed something or am doing something incorrectly, it doesn't seem like data validation with a drop-down list works when the spreadsheet is on a web page. Anyone know of a work-around for this if it's possible or what I'm missing?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 30 Times in 30 Posts
    If you save the worksheet as a .htm file, features such as validation aren't supported, and there is no way to make it work.

    You could publish the .xls file on the website instead. Depending on the user's settings, it will open in Excel within the web page, or in a separate Excel window.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •