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

R

ryanlillywhite

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

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

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

Thanks,
Rya
 
R

ryanlillywhite

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

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