Hi guys,

I have a couple cells in a word table linked to my excel worbook. The numbers link fine.

When I initially copy & pasted the cell, I formatted it to match my word formatting (even though I chose link to excel and match destination formatting).



Now when the numbers in excel change, the numbers change in the Word table, but the formatting get's thrown off. I have to manually go back and align center, unbold, font family, etc.
Can I somehow lock the Word doc formatting in place as to not have any manual interjection?

Thanks!

I'd suggest inserting the link as unformatted text. That way, the formatting will take on the attributes of the underlying paragraph in Word. If you try to override any of the formatting in a link within Word, your changes will be lost next time the link updates, even if the data don't change. The only exception is if you use a Charformat switch in Word to apply a specific format to the entire link.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]