Extending Sort Range
 

I am using Excel 2007. When I click on Data, Filter, Advanced; the range is
$A$5:$G$20. The actual range in the document is $A$5:$G330. When I enter
$A$5:$G330 in the Advanced Filter tab, it does not save the range. The old
range, $A$5:$G$20 remains. How can I correct this problem?