LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
Posts: 1
Default 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?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked excel tables in word document Bob Day Excel Discussion (Misc queries) 0 January 8th 08 06:18 PM
Formatting Word Tables Carlos Excel Programming 0 September 25th 07 06:32 PM
Excel 2003 losing Linked Cells Distressed Links and Linking in Excel 2 August 28th 06 09:49 PM
Problems printing a word document with linked excel tables. jcarlos Excel Discussion (Misc queries) 0 August 30th 05 04:01 PM
Pasting Excel To Word and resizing MTBer Excel Programming 2 May 16th 04 12:55 PM

All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"