Thread: [Solved] Keep formatting of linked Excel table when updating link in word
View Single Post
 
Old 11-12-2015, 01:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,379
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The unwanted resizing Excel object resizing (which is different from reformatting) is a known issue. In fact, it's by design. However, there is also registry key to prevent it. With Word closed, start the Registry Editor and navigate to:
• Word 2007 - HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Options
• Word 2010 - HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\E xcel\Options
• Word 2013 - HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\E xcel\Options
• Word 2016 - HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\E xcel\Options
Add a new DWORD value:
QFE_Boston
Set the new DWORD value to 1

As for the wrapping when using the 'Link and Keep Source Formatting' approach, the simple solution is to widen the column slightly in Excel.

Do note the embedded Excel objects cannot span a page boundary. If that is something you're likely to encounter, you will need to use the 'Link and Keep Source Formatting' approach.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote