May 28 2021
06:18 AM
- last edited on
Feb 01 2023
12:38 PM
by
TechCommunityAP
May 28 2021
06:18 AM
- last edited on
Feb 01 2023
12:38 PM
by
TechCommunityAP
I'm trying to build automation of a tedious Word document by entering the info once in Excel and then inserting links at the right places in the Word document. Everything seems to work fine. But thenat some point Word simply loses all links.
I can't figure out all the conditions that cause this, but I was able to identify at least two:
I can rep on two completely different Windows 10 systems using a very simple Minimal (non)-Working
Example:
At this point everything works as expected. If you change the value of A1 the text field in Word is updated accordingly.
Now save and reopen the file. After acknowledging external links, pressing Ctrl+A F9 gives an error. I've seen two different messages. (an aside - how come error messages are not selectable? That would be helpful)
or
After that, where the field should be, there is only: "Error! Not a valid link"