Could you share us that corrupt file to test?
For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.
Have you tried using the built-in repair feature in Excel? To do this, open Excel and go to File > Open. Select the corrupted file and click on the arrow next to the Open button. From there, select "Open and Repair" and see if that resolves the issue. If that doesn't work, you can try using a third-party file recovery tool.