Changing Source excel file causes links in word to fail

[Bill Black]

I've got a Word document with about 600 links to an excel spreadsheet.
Updating the links works fine until the source excel file is changed thenword
changes some portion of the links from Unformatted Text to a spreadsheet cell.

Changing the links manually or with a macro there are some observed changes
in the links. The cells that change are changed from Automatic to Manual and
this happens to all of the cells on a single Excel row.

There's nothing wrong with the data and the spreadsheet formats are
identical. When I go back to the original settings I can change the name of
the excel spreadsheet and it links fine. The problems occur when I change
the name of the linked spreadsheet in word.

 

[macropod]

Hi Bill,

Check that the fields for the problem links have the required text format switch (ie \t or \r) and the \a switch.