I'm finding a very strange behavior with my OLE links in Word that are linked to my Excel workbook and hoping somebody may have seen this before or has any idea why.
My original OLE links look like the below.
Code:
{ LINK Excel.Sheet.8 "C:\\Data\\xxxx\\12-14\\xxxxx WPs.xlsm" "Cover Charts!Charts_Cover_Main" \p }
However, after I either email the file, or transfer the file to our network to another computer, the link is changing as follows:
Code:
{ LINK Excel.Sheet.8 "C:\\Data\\xxxx\\12-14\\xxxxx WPs.xlsm!Cover Charts!Charts_Cover_Main" \p }
Now, If email the file back to the original computer, the LINK changes back to the correct first one.
So it appears that transferring the file from 1 pc to another is changing the link slightly, and thus can not update the charts without a manual search and replace first to fix it.
anyone see something like this? This is in 2007.