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.
Exactly this. It's highly frustrating to have keyboard shortcuts to functions used multiple times daily taken away.
How can I assign the old keyboard shortcut link for edit links (alt-a-k in my version) back to edit links? It's now linked to workbook links.
change it back, please! this is such a nightmare
In Excel go to File -> Options -> Customize Ribbon ->
under "Customize the Ribbon" right side of pane, expand the Data group. Add new Group to Data. (it may add to Home tab, in which case, drag it down to Data section if that's where you want it to appear). From left side "Choose commands from:", change to "All Commands". Add "Edit Links" to group created on the right side "Customize the Ribbon".
GREAT this was really helpfull.
If you wanna make Microsoft maybe add this as default for all, you may need to vote in the feedback forum to any concerning this topic under Excel as they mostly don't look here in this forum, sadly. https://feedbackportal.microsoft.com/feedback/idea/5a8ddfa5-ed94-ee11-a81c-0022484f9f6d
Same question from me - how I do I revert back Alt-E-K to be edit links...?
+1 to the "I don't like this change" group