'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Edit and Check Workbook Links in New Excel
Question details
The user needs to locate, edit, and manage external workbook links because the 'Edit Links' command is no longer visible by default in the newer Excel interface.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Managing external workbook links, updating data sources, or breaking links in an Excel document.
- Observed behavior
- The Edit Links command is missing or hidden in newer Excel versions, preventing the user from easily accessing the link management options.
Ensure your Excel workbook is saved and check if you have access permissions to the external files linked within your current document.
Restore the Edit Links Command via Ribbon Customization
Add the missing Edit Links command back to your Data tab for quick access to external source management.
In newer versions of Excel, the classic Edit Links dialog is hidden by default. You can manually restore it by customizing the ribbon settings.
Right-click anywhere on the Excel ribbon at the top of your screen and select 'Customize the Ribbon' from the context menu.
In the Excel Options dialog, change the 'Choose commands from' drop-down menu to 'All Commands'. Scroll down the alphabetical list until you find 'Edit Links'.
On the right side, select the 'Data' tab. Click the 'New Group' button at the bottom to create a custom group where the command will reside.
With your new group selected, click the 'Add' button in the middle to move 'Edit Links' over. Click 'OK' to save your changes. The command will now appear on your Data tab.
Manage Spreadsheet Links Effortlessly in WPS Office
Frustrated by missing features and constantly changing interfaces in newer Excel versions? Try WPS Office. It provides a familiar, classic interface where managing external workbook links is intuitive, straightforward, and completely free of charge.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file containing the external links.
- 2. Navigate to the Data tab: Click on the 'Data' tab located on the top ribbon.
- 3. Click Edit Links: Click the 'Edit Links' button directly visible in the menu to open the link management dialog.
- 4. Manage your sources: Select any linked source from the list to update values, change the source file, or break the link instantly.
Frequently Asked Questions
Why is the Edit Links button missing in my Excel?
In newer updates to Microsoft Office 365, the interface was modernized and simplified. The classic Edit Links dialog was replaced by a new 'Workbook Links' side pane, removing the old button from the default Data tab ribbon.
How do I find all external links hidden in an Excel workbook?
You can locate hidden external links by pressing Ctrl + F to open the Find dialog, searching for '.xl' (which catches file extensions like .xlsx or .xls) in 'Formulas', or by checking Name Manager (Ctrl + F3) and Data Validation rules for external references.
What happens when I break a link in my workbook?
Breaking a link converts all formulas that reference that external source into static text or numbers. This action cannot be undone, so it is highly recommended to save a backup copy of your file before breaking any links.
Can I update linked data without opening the external source file?
Yes, you can update external links in the background. Navigate to the Data tab, click 'Refresh All', or configure the workbook settings (via Edit Links > Startup Prompt) to update links automatically whenever you open the file.
