ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Inserted linked Excel tables in word resizing/losing formatting (https://www.excelbanter.com/links-linking-excel/448716-inserted-linked-excel-tables-word-resizing-losing-formatting.html)

Look13 May 6th 13 08:29 PM

Inserted linked Excel tables in word resizing/losing formatting
Hi - Apologies if this question is answered elsewhere but I can't find a solution.

I have a word (2010) document that has multiple tables inserted as linked tables from various excel (2010) files and tabs.

The majority of text formatting was done in Excel first. Once inserted I adjusted column widths and row heights to make the table fit the page and added decimal tabs to align numbers. I then ticked the 'preserve formatting after update'.

My issue is that whenever I update the links for the document a number of tables automatically resize and no longer fit the page (primarily where text is wrapped to fit in the column). I am unable to prevent these tables from auto-resizing as if I adjust the table properties to say do not resize the box defaults back when the link is updated.

There are about 100 tables in my document and re-formatting them after each update isn't feasible - Please can someone advise?


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.