Fields Shift When Adding Columns to DDE Linked Excel Spreadshe
"Doug Robbins - Word MVP" wrote:
It sounds like you might have used field matching to match the fields in
your data source to the "standard" field names. That is not necessary and
you can just insert your actual field names in the configuration that you
want them.
In this case however, you will probably need to edit the main document by
deleting the existing mergefields (or at least those that are not returning
the correct data) and then reinsert the required fields in the places that
you want them.
Deleting the merge fields and re-inserting doesn't help. It has to do with
something causing the data to shift from the columns when reading through
DDE. In fact, some data won't pull from Excel via DDE; it doesn't appear
under any field.
I tried creating a new Excel sheet from scratch and putting in all the
columns but it still pulls incorrectly.
|