Strange OLE Link Behavior after emailing or moving a File

ptmuldoon · #1 12-03-2014, 02:06 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Question about moving .pst file and personal folders	General_T	Outlook	1	12-28-2012 08:12 PM
Strange line appearing in file exported from PDF	Behonkiss	Word	1	09-05-2012 11:05 PM
Microsoft Office Windows Strange Behavior	jg60	Word	8	06-14-2012 09:51 AM
Outlook Auto-Reply Rule - Strange behavior	albracco	Outlook	5	09-27-2011 08:18 AM
Pasting - strange behavior	SatControl	Word	5	02-14-2010 12:57 PM