Office Settings & Configuration

How to View Linked Workbook Status in Excel

Maira Mehtab Oct 9, 2026 869 views

Question details

The user needs to see the specific status (open, closed, or refreshed) of external workbook links, because the default Workbook Links menu only displays the file names.

How to View Linked Workbook Status in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Managing and verifying the status of external data references within a spreadsheet.
Observed behavior: The modern Workbook Links pane only lists the names of linked files, lacking detailed connection status indicators like whether the source file is currently open or updated.

Before you start

Ensure you have saved your current workbook and that you are aware of the network locations or folders where your external source files are stored.

Solution 1Recommended

Use the Legacy Edit Links Command

Add the classic Edit Links tool to your Excel ribbon to view the detailed status of all external workbook links.

Excel's modern interface has simplified the Workbook Links pane, which hides specific status details. To see if a workbook is open, closed, or refreshed, you can restore the legacy 'Edit Links' command.

Open Excel Options

Click on 'File' in the top-left corner of Excel, then select 'Options' at the bottom of the menu to open the Excel Options dialog box.

Customize the Ribbon

Click on 'Customize Ribbon' in the left-hand pane. Under the 'Choose commands from' dropdown menu, select 'All Commands'.

Add the Edit Links Command

In the right-hand pane, click 'New Group' under your preferred tab (e.g., the Data tab). Scroll down the list of commands on the left, find 'Edit Links', select it, and click the 'Add' button in the middle to move it to your new group. Click 'OK' to save.

Check Link Status

Navigate to the tab where you added the command and click 'Edit Links'. A dialog box will appear displaying all linked workbooks and their exact status (Open, Closed, or OK) in the Status column.

Update Status: If the status of a linked workbook displays as 'Unknown', simply click the 'Check Status' button on the right side of the Edit Links dialog box to refresh it.

Effortless Data Management

View and Manage Workbook Links Directly in WPS Spreadsheet

WPS Spreadsheet provides a straightforward Edit Links feature built right into the default Data tab. This allows you to easily view link statuses, update values, and manage external references without having to manually customize your ribbon.

1. Open your file in WPS: Launch WPS Office and open the spreadsheet that contains external links.
2. Navigate to the Data tab: Click on the 'Data' tab located in the top ribbon menu.
3. Access Edit Links: Click on the 'Edit Links' button to open the comprehensive link management dialog.
4. Review Link Status: Check the status column to see the exact state of your linked workbooks, and use the provided buttons to update values or break links as needed.

Instantly view if linked workbooks are open, closed, or unknownFully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight application with a familiar, easy-to-navigate interfaceSeamlessly update or break external links with one click

microsoft office alternative - wps office

Frequently Asked Questions

Why does the status of my linked workbook say 'Unknown' in the Edit Links dialog?

Excel does not always automatically verify the status of external files to save processing power. You can resolve this by opening the Edit Links dialog and manually clicking the 'Check Status' button to force a refresh.

How can I find where the external links are located in my spreadsheet?

You can use the 'Find' feature (Ctrl + F) and search for the bracket symbol '[' or the file extension '.xl' (like .xlsx). This will highlight cells containing formulas that reference external workbooks.

Can I permanently remove a link to an external workbook?

Yes. In the Edit Links dialog, select the linked file you want to remove and click 'Break Link'. This action will convert all formulas referencing that specific workbook into static text or numeric values.

Office App Problems