Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've created a drop down list on a google docs spreadsheet but when I download the spreadsheet and open it up under excel, the drop down functionality is lost and only the first item is shown.

I have also tried doing it backwards (first creating the drop down under excel and uploading it) with no success.

Also tried both ways, selecting from a range, or typing in your own range.

Any suggestions?

share|improve this question

migrated from Jan 16 '13 at 7:12

This question came from our site for professional and enthusiast programmers.

What kind of suggestion? Like you said, it's not compatible. Were you hoping for some kind of work around that somehow makes docs compatible with Excel? – Ajedi32 Jan 16 '13 at 21:45

Like you said, Google Docs isn't 100% compatible with MS Office. So of course some features in docs don't work correctly when you open them in Excel, and vice-versa. There isn't a whole lot you can do about this, it's something Google would have to fix.

You can, of course, upload the Excel file without converting it to Google Docs format. But then you won't be able to edit it online using Google Spreadsheets. If you really need an online editor that's fully compatible with Excel, you can use Microsoft's own cloud storage solution: SkyDrive.

share|improve this answer

You must log in to answer this question.