title: Excel Advanced Filter Very slow to run, but only after autofilter has been run
body: <p>I have a very difficult issue I have been trying to solve for a few days, I would very much appreciate some help as I have tried to research this issue completely already.
  One one sheet I have a database (18 columns and 72,000 rows) in 32 Bit Excel 2010, so its a large database. On this sheet I also have some entries to auto-filter some columns, as well as an advance filter. When I run the Advanced filter, the data filters in 1 second exactly. If I run an auto-filter, (via vba macros) then run advance filter afterwords, the Advanced filter takes 60 seconds to run, even <em>after</em> turning autofiltermode to false. Here is what i have tried but no luck</p>
  
  <ul>
  <li>Removing all shapes on the sheet</li>
  <li>THere are no comments on the sheet so none to removed</li>
  <li>Removing all regular and conditional formatting</li>
  <li>Turning off auto-filter mode</li>
  <li>Setting all cell text on the sheet to WrappedText = False</li>
  <li>Un-protecting the sheet</li>
  <li>Un-hiding any rows and columns</li>
  <li>Removing any sorting (.sort.sortfields.clear)</li>
  </ul>
  
  <p>What else could cause this code to run 60 times slower but only after autofilter has previously run on the sheet, and how can i return it to that state? Any and all help would be greatly appreciated</p>