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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.