Why did Microsoft change the "Edit Links" to "Workbook Links" in the Queries and Connections tab?

Anonymous
2023-09-06T15:04:07+00:00

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!

Microsoft 365 and Office | Excel | For business | Windows

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.

0 comments

44 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2023-09-08T14:02:35+00:00

    Hi James

    How do I add back the old EDIT Links to the ribbon? have had a look in Excel option- Customise Ribbon but it's not immediately obvious.

    Why, why do Microsoft make these changes without testing it with users?

    thanks

    Sharon

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-09-08T14:26:05+00:00

    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".

    Was this answer helpful?

    60+ people found this answer helpful.
    0 comments
  3. Anonymous
    2023-09-08T14:35:52+00:00

    That's brilliant thanks Margaret

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. Anonymous
    2023-11-15T09:48:49+00:00

    With the workbook links when I try to open a linked file, when open the file the excell close all the files and try to repair the files.

    Have already happen this issue?

    Was this answer helpful?

    0 comments