Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
parkman parkman is offline
external usenet poster
 
Posts: 1
Default Excel Tables as Links in Word 07

i have a word document with several excel tables as links, so that i can
easily update the data.
however i face a very annoying problem. each time the data gets updated (be
it manually by clicking update in the menu or automatically when opening the
document, after some data was changed in the excel file) the formatting gets
lost. is there a way to solve this?
  #2   Report Post  
Posted to microsoft.public.word.tables
Pamelia Caswell via OfficeKB.com Pamelia Caswell via OfficeKB.com is offline
external usenet poster
 
Posts: 468
Default Excel Tables as Links in Word 07

What formatting is lost? How are you pasting, as formatted text (RTF) or HTML?


Pam

parkman wrote:
i have a word document with several excel tables as links, so that i can
easily update the data.
however i face a very annoying problem. each time the data gets updated (be
it manually by clicking update in the menu or automatically when opening the
document, after some data was changed in the excel file) the formatting gets
lost. is there a way to solve this?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200911/1

  #3   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Excel Tables as Links in Word 07

Hi parkman,

Whatever formatting is being lost is because someone has tried to override the format in which the data are obtained via the link.
The only reliable way to apply a particular different format to the data is via a Charformat switch - which will apply that format
to the whole of the linked data. Thus, if you need different formats for different portions, you might consider using separate links
for each and applying the Charformat switch accordingly. See Word's Help file for more details.

Alternatively, apply some suitable Style names to the various ranges in Excel and format those Styles appropriately in Word.

--
Cheers
macropod
[Microsoft MVP - Word]


"parkman" wrote in message ...
i have a word document with several excel tables as links, so that i can
easily update the data.
however i face a very annoying problem. each time the data gets updated (be
it manually by clicking update in the menu or automatically when opening the
document, after some data was changed in the excel file) the formatting gets
lost. is there a way to solve this?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Links to Excel Pivot tables and Charts taking around 3 hours to up Paras Jain Microsoft Word Help 0 July 15th 09 10:11 PM
Word links to Excel John T[_2_] Microsoft Word Help 1 August 4th 08 02:26 AM
controlling tables in word linked to excel tables cdstorage Tables 2 February 8th 06 02:16 PM
Word to Excel links CAE1030 Microsoft Word Help 3 January 20th 06 05:37 PM
browse word document faster even with macros, links & tables L. Richards Microsoft Word Help 0 November 21st 05 10:08 PM


All times are GMT +1. The time now is 03:02 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"