Share via

Excel sheet that will time out when trying to edit

Franklin, Shannel 0 Reputation points
2026-06-04T20:18:06.49+00:00

Excel sheet that will time out when trying to edit. How do i fix

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bulldog 2,285 Reputation points
    2026-06-04T22:13:39.0933333+00:00

    Given how little detail you included with your question, we are forced to guess at what you're asking about. Here's my guess:

    You are using the online version of Excel, which is a web page, and like all web pages, it will eventually time out if you don't keep actively using it.

    Was this answer helpful?

    0 comments
  2. Hendrix-C 17,145 Reputation points Microsoft External Staff Moderator
    2026-06-04T20:56:56.45+00:00

    Hi @Franklin, Shannel,

    For the best possible assistance, could you provide more detailed information about the situation? I appreciate your understanding and cooperation. 

    • When you said "time out", what exactly happens with the Excel file (it freezes and closes, shows Not Responding status, unexpectedly crashed, etc.)?
    • Which action triggers the problem (as soon as you open the file, when clicking into a cell, when saving, etc.)?
    • Does the issue happen when you open the file in Excel Desktop app, Excel Web version or opening through Teams? Does this issue happen with only one file or all Excel files?
    • Do you see any error message or error dialog box? If yes, please share me a screenshot or the full wording of the error.

    Please understand that my initial response may not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution. 

    Thank you for your understanding and cooperation. I look forward to hearing from you. 

    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.

    Was this answer helpful?

    0 comments

  3. AI answer

    2026-06-04T20:18:28.39+00:00

    A common cause of Excel timing out or becoming unresponsive when editing is that the workbook is very large or has excessive formatting and features that make loading and editing slow, especially in Excel Online.

    To fix this, reduce excess formatting and unsupported features in the workbook:

    1. Use the Inquire add-in to clean excess formatting (Windows desktop Excel):
      1. Open the workbook in Excel (desktop).
      2. Select File > Options > Add-ins.
      3. At the bottom, in Manage, choose COM Add-ins, then select Go.
      4. Check Inquire, then select OK.
      5. A new Inquire tab appears on the ribbon. On that tab, select Clean Excess Cell Formatting.
      6. Save the workbook and try editing again (especially if using Excel Online).
    2. If the workbook is used for co-authoring and shows “locked” or similar issues when timing out, remove features that block co-authoring:
      • Turn off the Shared Workbook feature.
      • Remove password encryption or restricted access via File > Info > Protect Workbook.
      • Turn off Refresh data when opening file on all tables and PivotTables (select the table/PivotTable, then Table Tools Design > Refresh > Connection Properties and clear Refresh data when opening file).
      • Disable any add-in that might be locking the file via File > Options > Add-ins.
    3. Ensure the file format supports co-authoring (if multiple people are editing):
      • Save the file as .xlsx, .xlsm, or .xlsb via File > Save As and choosing one of these formats.

    If the timeout occurs when exporting or loading data from SharePoint into Excel, increase the Excel timeout value:

    1. Open Registry Editor.
    2. Go to the appropriate key for the Excel installation (MSI or Click-to-Run, 32/64-bit) under ...\Office\16.0\Access Connectivity Engine\Engines.
    3. On the Edit menu, select New > DWORD Value and name it DataFetchTimeout.
    4. Right-click DataFetchTimeout > Modify.
    5. Set Base to Decimal, and Value data to 90000 (milliseconds), then select OK.
    6. Close Registry Editor and test again. If needed, increase the value further.

    Note: Editing the registry is advanced and should be done carefully; incorrect changes can affect the system.

    References:

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

    Was this answer helpful?

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.