Excel for the Mac doesn't currently have Open and Repair like Excel for the desktop. However here are several options.
-
Use the Mac Time Machine to roll back to a good version of the file.
-
Restore a previous version of a file without unwanted changes
Repairing a file isn't currently possible in Excel for the web. You can, however, repair a file in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.