Excel data problem in Word

[Colin956]

One of my Directors has a problem with Excel data embedded in Word documents.
If I open a document, the Excel sheet is displayed ok but when he opens the
same document he gets the following instead of the spreadsheet fields:

{EMBEDED Excel.Sheet.12}

I’m sure that there is a simple explanation for this but I’ve not come
across this problem before, can anyone help?

Colin

 

[DeanH]

Check in Tools, Options, View, Field Codes is not checked.
To toggle all field codes in the document in one go, Alt+F9.
To refresh all fields in the document, Ctrl+A (to select whole document),
then F9.
Track changes can stop updating of field codes.
The codes could be locked, then use Ctrl+Shft+F11 to unlock.
This is for 2003 and prior, instruction may be different for 2007.
Hope this helps
DeanH

 

[Colin956]

Hi Dean
That was it, thanks. I knew it would be simple (but not that simple). The
Director is impressed!

Colin

 

[DeanH]

Glad to assist with your future performance review with the boss ;-)
All the best.
DeanH