If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Excel Data List - why does it delete the data below the list?
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/ |
Thread Tools | |
Display Modes | |
|
|