Hi Kenneth,

I encounter similar problems and I found out a workaround. First goto the last row where you have data and press Shift+Ctrl+End which would select all those extra rows. Then choose menus "Edit, Clear, All". Save the file and retrieve again. It will be ok.

Regards

>The problem: In excel if I have 100 rows and 5 columns and I press Ctrl+End it will take me to cell E100. If I then delete some rows and columns and press Ctrl+End it will still take me to cell E100.
>
>Does anyone know the way to set what the data area is? There was a way to do this and it's probably still done the same way, but I can't remember what it was. I was thinking I assigned the area a name. I was thinking it was similar to how the cell range "print_area" is named when you set the print area. The assistant has been no help (bad dog or paperclip as the case may be).
>
>This is not just inconvenient. It's makes me have to put a subtotal in cell E101 in order for the auto filter to not hide it when active.
>
>Thanks