Forum Discussion
mlkolb15
Dec 12, 2018Copper Contributor
Linked Excel Tables in Word - Changed File Name, Link Broken
Hello!
I am working on a Word document with dozens of tables. I have pasted all of the tables from my Excel file into the Word document using "Link and Keep Source Formatting." I cleaned up my excel file by changing the names on a couple of tabs, and now I get this error:
"The item name "tab name!cells" of link "file path to excel file" cannot be found.
Is there a way I can go through all of the linked items to do a blanket update? Is there another way to fix this without re-pasting and reformatting dozens of tables?
Thanks!
1 Reply
Sort By
- Thuyavan GanesanSteel ContributorHi This happens when one file's content placed as reference .
you need to do some registry settings ..
Please go through the below article and
https://social.technet.microsoft.com/Forums/en-US/f5951bd0-8caf-4b6a-af65-d975f681e31e/links-between-word-and-excel-do-not-work-if-source-file-is-not-opened?forum=word
Hope this helps,
Thanks