[Excel 2007] My filters are reset when I refreshed data from web


  • I am using Excel 2007 to try and import market data for a game, Eve Online. I have the data coming in fine (Prices that certain items sell for at certain places), but I want to pull the data from only one market, not all markets in the game. I set about applying filters, which worked fine. The problem is, when I refresh the data, it clears all the filters and now I'm looking at 400+ markets instead of the 1 I want to look at. Is there a way to refresh data and have the filters only show the 1 market, or do I have to manually configure all the filters for all columns in all sheets every time I refresh data from web?
    Tuesday, May 21, 2013 9:10 PM