[Solved] Autofilter - delete filter is unavailable

[humulus]

Hi,
the other day I made a filtering with Autofilter. After that I saved the calc sheet as Excel 2007 and ended the session. Now I can't delete the filter to get all lines back (they are there, I can see it from the line numbers) as the option Data - Filter - Delete filter is grey. I get the same problem with the file converted into .ods.

[FJCC]

Try selecting the entire filtered region and then go to Format -> Row -> Show.

[humulus]

Thanks, now all rows are visible. However, I've met another problem which I haven't seen before. When I start Autofilter and click at the arrow I don't see the contents of the column, just the rows All, 10 highest an Standard filter. When I click on 10 highest nothing happens but Standard filter works normally and the autofiltering in a testfile as well.

[Villeroy]

menu:Data>Select...
You may see some name like "Excel_Autofilter...". Select that one. This is the range that is supposed to be filtered.
If it is the wrong range call menu:Data>Define... select the "Excel_Autofilter...", adjust the reference, click [Modify] and [OK]
If there is no database range like "Excel_Autofilter...", select the whole list range, call menu:Data>Define... define a named database range, click [Add] and [OK].
Now you will not lose the filter settings anymore.
Do not append new data below the list. Always insert new cells and delete unwanted cells rather than clear contents. This way all your named and unnamed references [such as sum(A2:A99)], charts, conditional formattings, validations and data pilots refer to the correctly sized list range.
Storing data in a database and link them by means of import ranges in spreadsheets would solve all of those problems (losing Excel compatibility though).

[humulus]

Thanks a lot - it works.