View Single Post
 
Old 12-31-2016, 01:06 PM
Fabulist Fabulist is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Sep 2015
Posts: 33
Fabulist is on a distinguished road
Default How to find Word links (fields) to blank Excel cells?

Hello,

I have a Word file with multiple linked items, mostly cells with words or numbers, from an Excel file, and I noticed that old links leading to now empty cells still exist. This happened because the Excel file evolved over time and the Word file got its fields updated, hence I was not able to see the previous link to delete it, as there was nothing visible where the linked item used to be.

Field Shading does not shade these links to the blank Excel cells, and they are near impossible to trace since they seem to take no space, but are visible through Alt + F9 -
this is how I caught a couple, since I saw a link in a place where there should be none. However, due to the fact there are areas where there are multiple links stacked together, I cannot identify which should be there and which should not.

Is there a way to track these links to empty cells and eliminate them? For example, highlight links to empty cells?

Thank you in advance.
Reply With Quote