how to fix an excel issue

Thomas Fasano 0 Reputation points
2026-09-21T00:14:36.7833333+00:00

I have created an excel worksheet. when i go back into edit the spreadsheet it pops up with an error message. it states repair, help or close. On anyone of those choices it closes the spreadsheet. how do I correct this.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-09-21T00:14:51.8866667+00:00

    Try these steps in order:

    1. Repair the workbook itself.
      • Open Excel.
      • Select File > Open.
      • Browse to the workbook.
      • Select the file.
      • Select the arrow next to Open, then choose Open and Repair.
      • First choose Repair.
      • If that does not work, repeat the steps and choose Extract Data to recover values and formulas.
    2. If the workbook is stored on a network location or external drive, copy it to the local drive first, then try Open and Repair again. Disk or network errors can prevent the file from opening correctly.
    3. If the workbook was already open when it became corrupted, revert to the last saved version.
      • Select File > Open.
      • Double-click the workbook name.
      • Select Yes to reopen it.
      • This removes unsaved changes that may have caused the corruption.
    4. If the problem happens with Excel files in general, repair the Office installation.
      • Close all Office apps.
      • In Windows, go to Settings > Apps > Installed apps.
      • Find Microsoft 365 or Office.
      • Select Modify.
      • Run Quick Repair first.
      • If the issue continues, run Online Repair.
      • Note: Online Repair reinstalls Office components and can take 15–30 minutes.
    5. If the file opens after recovery, turn on AutoRecover to reduce future data loss.
      • In Excel, select File > Options.
      • Open the Save category.
      • Check Save AutoRecover information every and set the interval.
      • Confirm Disable AutoRecover for this workbook only is unchecked.

    If the workbook still closes immediately, the most likely next step is recovering data from the file with Open and Repair or Extract Data, then using Online Repair for Excel itself.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Estrella721 46,260 Reputation points Independent Advisor
    2026-09-21T00:48:17.6366667+00:00

    Hi,

    What changes did you make to your computer or subscription before the issue started?

    Instead of Quick Repair, I suggest trying an Online Repair to thoroughly repair any issues with the Office installation:

    In the search bar, type Control Panel > Programs and Features > find Microsoft 365/Office > right-click it > select Change > then run Online Repair.

    If the issue persists, you can use the Office Uninstall Support Tool (Uninstall Troubleshooter) to completely remove Microsoft Office from your device and then reinstall it:

    https://aka.ms/SaRA-officeUninstallFromPC

    Once you open the link, click Get Help. When the tool launches, select Yes, then click Next. Choose the option to uninstall Microsoft 365 and follow the on-screen instructions to complete the process.

    To reinstall Office:

    Go to https://account.microsoft.com/services

    Sign in with the Microsoft account associated with your Office license.

    Locate Microsoft Office and click Install.

    Run the downloaded installer and follow the on-screen instructions.

    Once installed, open an Office app such as Word or Excel and sign in with the Microsoft account associated with your purchase to activate Office.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.