After performing an append query on a list containing duplicates, I exported the new table as a new sheet into a pre-existing Excel file containing approximately nine other sheets.

When I click on the file to open it, I get an error message stating File Error: Data May Be Lost. When the file opens, the first worksheet appears to be fine, but the other nine plus the new one that I exported from Access are jumbled as if the file had been corrupted.

I tried the "Open and Repair" option but to no avail. Is there anything I can do to restore the data? I am an intermediate level user, so nothing too programming-heavy, please.

Thanks,

Jamie