Unable to open one excel document.

Shubhraj, Shubhraj (AGD) 0 Reputation points
2026-09-15T01:41:58.1166667+00:00

Hi, I work for Government of South Australia. The suite of Microsoft Office is purchased & managed centrally. I have problem in opening one of the excel files. Initially it asks for the options to update/ do not update the external links of the file and after that it remains as blank document. Need help to rectify the problem & make the file accessible.

Thanks.

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

1 answer

Sort by: Oldest
  1. Jade Ng 15,490 Reputation points Microsoft External Staff Moderator
    2026-09-15T02:22:56.4033333+00:00

    Dear,

    I understand how frustrating this can be, especially if the workbook contains important data.

    To better understand the issue, could you please let me know:

    1. Are you the only user experiencing this issue, or do other users encounter the same behavior when opening the file?
    2. Can the workbook be opened successfully on another device?
    3. Which version of Excel are you using?
    4. Is the file stored locally or OneDrive/SharePoint?

    In the meantime, please try the following troubleshooting steps:

    • Open Excel first without opening the workbook.
    • Go to File > Open > Browse.
    • Select the affected workbook, click the arrow next to Open, and choose Open and Repair.

    Untitled

    • If the workbook still opens as a blank window, launch Excel in Safe Mode by pressing Windows + R, typing excel /safe, and then opening the file again.

    Since Excel is prompting to update external links, the workbook may contain references to other files. The prompt appears when links exist in formulas, named ranges, charts, pivot tables, queries, or hidden objects.

    You may also wish to check the following:

    • Search the workbook formulas for [ which often indicates an external workbook reference.
    • Review Formulas > In the Defined Names section, click Name Manager and remove any named ranges that reference external workbooks.
    • Check charts, PivotTables, and Data > Queries & Connections for connections to external files.
    • Save the workbook as a new file name and test again.
    • Run File > Info > Check for Issues > Inspect Document to identify and remove unwanted external references.

    Untitled

    If none of the above solutions work, please let me know, and I will be happy to guide you through the next steps.

    I appreciate your cooperation and look forward to your update.


    If the answer is helpful, please click "Yes" 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.

    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.