Probably a stupid question but, if you can open the workbook, can't you just copy the "live" rows to a new workbook and save that?

Regards