File saving issue on Excel in MacBook Air

II 0 Reputation points
2024-06-27T01:46:03.2166667+00:00

I was trying to save an excel file and the message: "Errors were detected while saving [file name] 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." is shown. It doesn't matter which option I choose, when this pop up closed, the "SAVE" button flash automatically and the pop up shown again, and the loop continue, practically freezing the app. At this point I don't even care if I can save this particular file, but there are other excel files that I am working on are not saved, how can I get out of this loop so I can go and save those files?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,641 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 7,145 Reputation points Microsoft Vendor
    2024-06-27T08:45:28.4+00:00

    Hi @II

    Does this issue occur with new created Excel file and other Office files, such as Word document?

    Which versions of Mac OS and Office for Mac are you using now?

    To check the Office version, you may go to Excel, go to Excel menu, and click About Excel. It's recommended to update the Office to the latest one (16.86 (24060916).

    Please try other folders/ different locations to save.

    Then I suggest you remove the Excel cache and configuration file from the Library folder.

    • Completely quit all Office applications
    • In Finder, press Command +Shift + G and enter ~/Library to open Library folder.
    • In the Library folder, open Containers folder and remove the folder “Microsoft.Excel”.
    • Restart Mac and relaunch the Excel application to see the results.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.