Share via

Hyperlinks between Excel and Word no longer exist

Jack Gill 1 Reputation point
2021-10-11T05:19:54.877+00:00

I have been using dynamic hyperlinks between Excel and Word to put cell into a word document/report for several years now with no real problems.

Now, randomly, the links, when refreshed, state that the object cannot be found, and then changes the text to "object does not exist". And I know this to not be the case as I have the excel file open on my laptop to copy the text.

I noticed that some links come across as %20 in place of a space, and others have spaces. I have tried both formats and the links continue to break.

Any assistance would be gratefully appreciated as I am very much dependent upon my links for automation purposes.

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,238 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
944 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,747 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,691 Reputation points
    2021-10-11T08:55:27.427+00:00

    @Jack Gill

    Could you please share us how did you create the dynamic hyperlinks?
    What's the version of Office are you using now? Have you updated your Office or Windows system before this issue appeared?

    Currently, please right-click the the text of "object does not exist", check whether threre is the option of "Linked WorkSheet Object" and "Links" button.
    139344-capture12.jpg
    If yes, I suggest you take a screenshot for Links windows as follwoing.
    139340-capture13.jpg
    Besides, please provide the correcr path of the linked file. (If there is any privacy information, you could cover it on image, or use symbol "X“ to replace it when you paste characters here.)

    If your want to refresh your links, I suggest you press "F9" key instead of "Update Link" to have a check.

    Any updates, welcome to post back.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.