A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Links and Linking in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Inserted linked Excel tables in word resizing/losing formatting



 
 
Thread Tools Display Modes
  #1  
Old May 6th 13, 08:29 PM
Look13 Look13 is offline
Junior Member
 
First recorded activity by ExcelBanter: May 2013
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?

Thanks!
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 07: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:18 AM.


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