[geoschmo]

You might also try creating a new excel workbook, and then on the data tab click Import external data|Import data. Browse to your excel file you are having trouble with. It should then give you a list of the worksheets in that workbook without actually opening the entire workbook. It might still give you memory problems, but it might work. If it does you can save each worksheet as a separate workbook then.