File always corrupt

Excel for Mac corrupts .xlsm after editing VBA – “Removed Records: Formula / calcChain.xml” on reopen

Hello,

I am experiencing a reproducible issue in Excel for Mac (Microsoft 365).

Environment

• macOS: [please insert your macOS version]
• Excel for Mac version: [please insert exact version from About Excel]
• File type: .xlsm (macro-enabled workbook)
• Storage location: Local disk (NOT iCloud, NOT OneDrive)
  
  

  I can open an existing .xlsm workbook without any issues.

  However, the moment I:

  1. Open the VBA Editor
  2. Add or modify any macro (even something as simple as:)

  Sub TestStability()

  End Sub

  1. Save the file
  2. Close Excel
  3. Reopen the file

   

  Excel displays a repair message stating that content was removed, such as:

  • Removed Records: Formula from /xl/worksheets/sheetX.xml
  • Removed Records: Shared formula
  • Removed Records: Table
  • Removed Records: Formula from /xl/calcChain.xml
    • Formulas are deleted
    • Tables are broken
    • Workbook structure is modifiedNamed ranges may also be removed
      

      After the repair process:

    • The issue occurs even if the macro is NEVER executed.
    • The issue occurs even if only an empty Sub is added.
    • The file works perfectly until VBA is modified and saved.
    • Restarting Excel allows previously saved (older) versions to open normally.
    • The issue persists even after:
      • Resetting the Excel container
      • Removing ~/Library/Containers/com.microsoft.Excel
      • Removing ~/Library/Group Containers/UBF8T346G9.Office
      • Reinstalling Excel
        • Saving macro-enabled workbooks
        • calcChain.xml rebuild
        • ListObject / table XML regeneration after VBA modificationThe problem does NOT occur if no VBA changes are made.
          

           

          This appears to be related to:

          • calcChain.xml regeneration
          • ListObject (Table) XML rewrite
          • VBA project save interaction with worksheet formula XML
          • Possibly a Mac-specific saving engine issue

           

          It seems that saving the VBA project triggers corruption of worksheet XML structures.

          Is this a known issue in the current Excel for Mac build?

          Is there a known bug related to:

      • Any technical clarification or official workaround would be appreciated.

        Thank you.