Table Properties get lost with Excel link update

[Jason]

I have a table in word that takes data from excel via a link and certain
table properties, i.e. borders and text alignment get lost and revert back
after an update while others remain.

Any ideas?

 

[Mary12345]

Jason, I may have found the answer. Go to Tools, Options, then select the
Compatibility tab. Select the correct option in the Recommended options
for: box.

For me it was Microsoft Office Word 2003 because that is what we are using.
Now various formattings that were not holding are holding. It was strange
because this not holding business happened only sporadically.