Not Possible to Save

[fak119]

When trying to save a rather big spreadsheet, all of a sudden the following error alert appears:

Errors were detected while saving '/Users/imac/Documents/Excel Sports/Soccer/WTA 2024.xls'. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.

Whatever I try (repairing in various new files) or trying <Safe As> I always get the same error! I also tried to save without Macros.

What can I do in order not to lose the whole spreadsheet?

(Excel for Mac Version 16.32 (19120802) with licence Office 365)

[AliGW]

You have two options, I suppose:

1. Revert to an earlier saved backup. If you don't have one, ask yourself why not.
2. Copy and paste sections to a new workbook and keep saving in the hope that the error can be left behind in the old workbook.

[fak119]

Thank you; the question remains why Excel is not able to tell where the error is and why.

[AliGW]

That's a question for Microsoft, I'm afraid. It would be helpful if it could.

[romperstomper]

If you use a newer file format, it's usually better at identifying what it had to remove.