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.

Hi Bill,

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

-- 
Cheers
macropod
[Microsoft MVP - Word]


"Bill Black" <Bill Black@discussions.microsoft.com> wrote in message news:2CF3AE90-3CE1-4F02-B262-77A9636B4285@microsoft.com...
> 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.