View Single Post
  #1   Report Post  
Gary McGill
 
Posts: n/a
Default Linked excel table loses borders on update

Hi,

I have a Word doc with an embedded (linked) Excel worksheet. There's no
formatting on the Excel worksheet, and I apply formatting in Word. When I
update the field, my formatting (as applied in Word) is preserved, which is
good.

However, if I put borders on the table (in Word), then these are lost when
the field is updated. (Apparently the borders in Excel override the borders
in Word, and since there are no borders in my Excel spreadsheet, I end up
with no borders in my Word table). This is most definitely not good! :-)

I know that this was an issue with older versions of Word (see
http://support.microsoft.com/default...b;en-us;153210), but I'm
using Office 2003. Is this still an issue with 2003?

The KB article above suggests setting the borders in the source document,
but given that I'm applying all the other styles in Word, it would be pretty
awful if I had to maintain the table borders in Excel...

Are there any workarounds? Is there something I can do with the field code
or suchlike to prevent this behaviour?

Thanks in advance,
Gary McGill