I'm still working on finding the cause, but from what I can tell Word is modifying the LINK code when Word first opens.
I have done nothing then to simply open the Word Template file. And in testing, I see the link code is getting changed as follows
The File opens as the follow link
Code:
{ LINK Excel.Sheet.8 "C:\\Data\\Template\\Blank Workpapers.xlsm!Cover Charts!Charts_Cover_Main" "" \p }
and then changes to the following
Code:
{ LINK Excel.Sheet.8 "C:\\Data\\Template\\Blank Workpapers.xlsm" "Cover Charts!Charts_Cover_Main" \p }
And I have done nothing other then simply open the Template file in word. You can see a couple of minor differences. The ! is removed by word, as well as that double ""
And Whats strange is the initial paste special link shows is what the second one listed. So Word is first changing the link on open, and then changing back to what it was originally pasted linked as?