C
CerfurMark
I am using VB.NET. I have a ListObject on an Excel worksheet. The
LisObject is populated with data. I also happen to have a QueryTable
positioned to the left of the ListObject that has the same starting row as
the ListObject. When the user selects a filter for one of the ListObject
columns, the ENTIRE worksheet rolls up and only the filtered data is
displayed, but this hides my QueryTable! For example, if my QueryTable and
ListObject are at row 7 and the unfiltered ListObject shows data down to row
2500, then when the user filters the data, Excel hides all the rows from 7 to
2500, and then displays the filtered data starting at row 2501. Now I can't
see any of my other data that is on rows 7 to 2500.
Is this the designed behavior of this control? Is there some way to make
the ListObject only affect it's own area?
LisObject is populated with data. I also happen to have a QueryTable
positioned to the left of the ListObject that has the same starting row as
the ListObject. When the user selects a filter for one of the ListObject
columns, the ENTIRE worksheet rolls up and only the filtered data is
displayed, but this hides my QueryTable! For example, if my QueryTable and
ListObject are at row 7 and the unfiltered ListObject shows data down to row
2500, then when the user filters the data, Excel hides all the rows from 7 to
2500, and then displays the filtered data starting at row 2501. Now I can't
see any of my other data that is on rows 7 to 2500.
Is this the designed behavior of this control? Is there some way to make
the ListObject only affect it's own area?