0

I am attempting to create a linked table in Word that is intended to update automatically from the source Excel document. The intent behind the linked table is to be able to quickly update all of the linked information in the word document automatically. Both files are hosted on SharePoint. I can copy and paste the table from Excel into Word using the "Link & Use Source Formatting" and the data appears as expected.

However, when you try to update the data (F9), an error pops up stating:

Word is unable to create a link to the object you specified. Please insert the object directly into your file without creating a link.

Clicking OK replaces the data with "Error! Not a valid link."

If I look to the Link Source window, I can see that the path to the Excel document appears to be pointing to Sharepoint, albeit with %20 replacing any spaces. Is there a different link/path option that can be used for direct linking?

Improve this question
3
  • I think the issue may be related to the path length limits. I may need to move the documents to a folder higher in the directory to reduce the path length. I'll update the question if this change resolves the issue. Commented Mar 14, 2022 at 17:49
  • Did you ever figure out a solution for this? Commented May 23, 2022 at 14:06
  • Sadly, no. Sorry @JohnGIS. Links would work if the path was shortened, but then re-opening the file would result in broken links again. Commented May 24, 2022 at 16:50

1 Answer 1

Reset to default
0

I had a similar issue. After looking at the file links, I noticed characters after the actual file name and extension.

Example: https://sharepoint.com/foldername/filename.png?csf=1&web=1&e=Pqj5Xi

I removed the text that appeared after the file extension and the links worked for me.

Example: https://sharepoint.com/foldername/filename.png

This can be done in bulk by using find and replace in excel using the wildcard "*" after the text you would like to remove, while leaving the replace field blank.

Example:

Find: ?csf= Replace:

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.