<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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? &nbsp;<br />
<br />
I've noticed that sometimes when it comes up, it is populated with the same range I defined previously (which is what I want). &nbsp;However, at other times, it is empty. &nbsp;Thus, I am trying to understand what determines each result so as to eliminate the one I don't want.<br />
<br />
BTW, the Criteria range field is always constant so the problems lies only with the List range.<br />
<br />
Thanks
</div>
</div>


Hello,

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.

Thanks

Advanced Filter box in Excel keeps asking for List range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.