| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Format Table linked to Excel
I have created a macro in Excel which names a range depending on the amount
of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Format Table linked to Excel
Hi Jason,
Which link format are you using? -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Format Table linked to Excel
Hi Jason, Which link format are you using? -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Format Table linked to Excel
Hi Macropod
I am using copy from Excel then Paste Special, Paste Link, HTML Format. Jason "macropod" wrote: Hi Jason, Which link format are you using? -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? . |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Format Table linked to Excel
Hi Macropod
I am using copy from Excel then Paste Special, Paste Link, HTML Format. Jason "macropod" wrote: Hi Jason, Which link format are you using? -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? . |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Format Table linked to Excel
Hi Jason,
Try using the 'Excel worksheet object' format instead. That should faithfully preserve the worksheet's formatting. Alternatively, you might try the picture format. -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... Hi Macropod I am using copy from Excel then Paste Special, Paste Link, HTML Format. Jason "macropod" wrote: Hi Jason, Which link format are you using? -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? . |
|
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Format Table linked to Excel
Hi Jason,
Try using the 'Excel worksheet object' format instead. That should faithfully preserve the worksheet's formatting. Alternatively, you might try the picture format. -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... Hi Macropod I am using copy from Excel then Paste Special, Paste Link, HTML Format. Jason "macropod" wrote: Hi Jason, Which link format are you using? -- Cheers macropod [Microsoft MVP - Word] "JasonC" wrote in message ... I have created a macro in Excel which names a range depending on the amount of rows used. I have then created a link in Word which is linked to the named range, so the table in Word only shows the used rows. The trouble is when I update the link, the formatting of the table is lost. I want the table to show gridlines and keep row heights and column widths. The column widths are a problem because when they update, they are different across each row ie, they don't line up under each other. Is there a way to fix this other than manually fixing the table after updating the links? . |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove spaces in a table in Word linked from Excel | Tables | |||
| How to allow Word table to expand or reduce when linked to excel | Tables | |||
| How do I insert a large linked Excel table into Word? | Microsoft Word Help | |||
| Page break in linked Excel Table | Page Layout | |||
| Linked excel table loses borders on update | Tables | |||
Linear Mode
