Originally Posted by
DeenaH
I cannot use the built-in linked fields, because rows and columns in the Excel sheet are constantly being added and linked fields as you know are referenced by row and column numbers.
That not really so, as you can use range names in the link field. If you move, expand or contract the named range, the LINK field will pick up those changes.
Originally Posted by
DeenaH
I am thinking that I will need to use DOCVARIABLEs. However, I am stuck. When I manually insert a DOCVARIABLE (Ctrl-F9), I can name it {DOCVARIABLE "VariableName"}, but when I click ALT-F9, I cannot see the field, because there is no name assigned to it.
A DOCVARIABLE field won't do any better, as it still needs a DOCVARIABLE that contains the actual content - not an external workbook reference.