Autofilter and blank columns

[tomc2]

I have a spreadsheet in which I use Autofilter a lot.

Until recently, the normal behaviour was that when I filtered on a column, it would show just the filtered rows, plus a load of empty rows at the very bottom where I could then enter more data. This was useful in that I could then enter more data without having to first cancel the filter.

Yesterday, I had reason to do some brief editing of the file in Libreoffice (on a Mac without Excel) and this seems to have upset it. Now, back on my normal PC with Excel 2003, what happens is if I do an autofilter, it does not show empty rows at the bottom - after the final record I just see a big grey space and no more row numbers. So to add more data, I have to cancel the autofilter.

Does anyone know if there is a setting somewhere that triggers this behaviour?

I could just restore from a backup (prior to the Libreoffice edit) to fix this, but it would be useful for me to know if there is an easy fix for this, and I do not have to be afraid of occasionally using Libreoffice to edit the file.

Thank you very much for any advice.

[dilipandey]

HI tomc2,

Welcome to the forum.

I can think of two options (without seeing the workbook):-
1) Re-apply the autofilter by just selecting the data (leaving the rows at bottom) and try again
2) check the excel compatibility (version) - not sure though

Regards,
DILIPandey

<click on below 'star' if this helps>

[tomc2]

Many thanks. In the end I decided it would be safer to restore from a backup, as I realised the data is too important to risk getting corrupted all the time. I also noticed after saving in Libreoffice the file size had increased massively for no obvious reason, so I have decided I need to stick to Excel only.

Thanks,

Tom