When using Advanced Filtering in Excel (2007), what would cause the List range field in the Advanced Filter box to come up empty each time after a previous filter?
I've noticed that sometimes when it comes up, it is populated with the same range I defined previously (which is what I want). However, at other times, it is empty. Thus, I am trying to understand what determines each result so as to eliminate the one I don't want.
BTW, the Criteria range field is always constant so the problems lies only with the List range.