Removing golf players from excel

[Drunkenight]

Does anyone know of any way to remove golf players from an excel spreadsheet? I just want to import the top 20 players in the US Open and trade them. When I link to excel, it pulls in all the players and there are over 150 of them. If I try deleting them, they just return on the next refresh. Any ideas?

[osknows]

Linking to Excel will write the full market to the sheet so there's no way I know of to restrict what's written to Excel.

If you know the top20 beforehand you could adda column to identify those golfers and use autofilter to select the required golfers. Eg see example http://www.mediafire.com/?82khzdh6hhknd7w

If the top20 change then you're better off ranking by odds and automatting a bet based on the rank.

[Drunkenight]

Thanks Osknows. I will have a look into that.