Excel Data List - why does it delete the data below the list?

I have a large database in an Excel spreadsheet with subtotal formulas
below. When I used the Data - List function to sort through the
database, a few things happened to the underlying subtotal data:

1. When I click out of the list, the cells in columns below the list
become blank.
2. The subtotals that are referenced by formulas in other sheets still
feed out as though the data were extant, though the cells appear
blank.

Why does the underlying data only show up when the active cell is in
the defined list? How can I fix it?

Thanks,
Ryan


---
Message posted from http://www.ExcelForum.com/

I figured it out. My subtotals data (below the Data List) had every
other row hidden, and selecting a cell within the list adds a row at
the bottom of the list, thus shifting all data in the corresponding
columns (but not the entire rows) down one row without changing the row
attributes.

Carefull, though, because any data under a List changes rows, but if
that data range (as does mine) extends to columns wider than the
defined list, the data that's not directly below the list doesn't
change; it won't match up with the original row anymore. Hmph.


---
Message posted from http://www.ExcelForum.com/