This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
You used to be able to see if the workbook had any external links from the paper clip icon- if it were blue, you knew there were links. Now the "Workbook Links" icon always shows a blue paperclip, even when there are no links, forcing you to open the pane to see if there are really any links. Changing data source in "Edit Links" was so much easier with the old functionality. The new pane is much more difficult to navigate. Please change it back!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
My biggest thing about the pane relative to the old Dialog is I am a keyboard shortcut user & more & more MS is moving away from being able to do things without the use of the mouse/touch-pad. For long-time users who've developed the use of keyboard shortcuts, these constant changes greatly affect efficiency.
How do we add back the Old Edit Link Button back to the Ribbon?
I was having the same issue as I heavily rely on keyboard shortcuts - the only fix i could find was to completely remove the new "Queries & Connections" group, and adding the custom "edit links". Removing the "Queries & Connections" defaulted the "edit links" to ALT+A+K (still going to have to get used to that as i was used to ALT+E+K).
I don't understand how Microsoft would think this update is helpful for people who use excel every day.
Hope this helps.
Re: How do I add back the old EDIT Links to the ribbon?
Manage workbook links - Microsoft Support
The legacy Edit Links command is replaced by the Workbook Links command. However, you can get the old Edit Links command back by adding the legacy Edit Links command to your custom group in the ribbon. You can't add the Edit Linkscommand to the Queries and Connections group.
- Pane vs. Dialog Ease of User
The task pane is supposed to be easier and better for Workbook Links.
Hi
new "Workbook links" does not allow to select multiple links and break links from multiple files at once. Very inconvenient as I want to clean up old links from a legacy file