Apparently there was a bug in CR9 where if you used a table in Excel CR would forget where that table was.  When trying to Set Datasource Location, you can't "map" anything because the Fields in the Original Table are all gone, it's as if the table is blank.

Supposedly there was a CR9 "fix" but it only fixed future reports, not preexisting.

I just upgraded to 2008 hoping it would solve the problem.  Other than recreating all my reports, does anyone know of a way to re-assign the table and map the lost fields?