OLE (Object Linking and Embedding) is like Xref in AutoCAD, but between two
different programs.
So not only must the 'other' source file always be in the same spot and
always called the same thing, the app that launched it must exist in the
same spot (and other small things) or Windows must use that app to open the
file.
Embedding from a temp dwg file does not work, sharing only the Excel file
with others does not work either.
In an Excel file where everything works, type CTRL+G (or Edit Menu>Go To)
and find out where Excel sees that file as residing. Repeat in the same
Excel file on another PC and see if the location is still available.
Also repeat in your posted Excel file on your PC where you created it: here
it shows nothing to open or go to... .
--
Dean Saadallah
http://LTisACAD.blogspot.com
--