[jmparsons]

On Jan 11, 1:21*am, "Peter Jamieson"
wrote:
I don't know what you mean by "re-execute the field."

I mean select it and press F9 to update its value.

Aha! That did the trick!!

I test using e.g.

a{ LINK Excel.Sheet.8 "[path]" "[cell reference]" [switches] }b

The switch combinations that work here a
1. \a \p (Inserts a picture linked to the cell)
2. \a \f4 \r (Inserts text with formatting using rtf)
3. \a \t (Inserts plain text)
4. \a \b (Inserts a bitmap image linked to the cell)
5. \a \t \u (Inserts plain unicode text)

It is now working just the way it is supposed to. I manually edited
the LINK code to remove the MERGEFORMAT and changed the switches to \a
\t.