If the entire workbook is embedded, a quick test here shows that you can use
simply the 'Sheet1!$A$1' link referenced just to the worksheet. ThisWorkbook
is only known to VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Wazooli" wrote in message
...
Does anyone know how to reference dynamicially named ranges in a chart
contained within an embedded chart in MS Word? I know how to do this in
Excel, but the name of the workbook is needed. As far as I can tell, the
name of the embedded book in Word is "ThisWorkbook", but I get an error
when
I try to use it.