I noticed a strange behaviour in Excel 2007 files.
In an empty file, I select a number of rows and hide them. Then if I select the first and last row where all rows are hidden and unhide them, everything is fine.
If I want to do this in a filled Excel file, it doesn't work. Why?