Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

i have created a file using MS Excel and saved the file as ODS but it will open on read only mode works perfectly but once i saved the file drop down list not working

share|improve this question
    
The only way you'll attract more attention to your question is if you improve it. Add more details, tell us what you tried and also give your question a title that makes it instantly clear what exactly your issue is. This makes it a lot easier for users to spot your question if they know the topic. –  Oliver Salzburg Aug 14 '12 at 16:27

1 Answer 1

Just open the spreadsheet in read only mode. copy all the data into new spreadsheet and save it. And apply filter using ALT+D+F+F. it will surely help you Out

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.