Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jcarlos
 
Posts: n/a
Default Problem with linked Excel table in a word Document

I have pasted an Excel table into a word document as a linked object.

When the excel table is changed at its source (i.e. inserting or deleting a
column) and then updated in the word document, some of the columns get cut
off.

Why is this happening? Is there a way to create the linked table from Excel
so that columns are not cut off if information in columns are added or
deleted?
--
jc
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

I *believe* that Word & Powerpoint simply store the address of the range you
pasted in. Then, after you change the spreadsheet, the original address
stored in Word no longer refers to the table you want presented. What you
see in Word is the current contents of the original address range.

In other words, I don't think you can accomplish what you want.


"jcarlos" wrote:

I have pasted an Excel table into a word document as a linked object.

When the excel table is changed at its source (i.e. inserting or deleting a
column) and then updated in the word document, some of the columns get cut
off.

Why is this happening? Is there a way to create the linked table from Excel
so that columns are not cut off if information in columns are added or
deleted?
--
jc

Reply
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
Word document embedded in Excel 2003 won't wrap brandxdesign&construction Excel Discussion (Misc queries) 0 May 18th 05 05:53 PM
excel table in a page of a word document, horizontally AC Excel Discussion (Misc queries) 1 May 16th 05 09:21 AM
Word table exported to Excel rwSRA Excel Discussion (Misc queries) 1 March 24th 05 08:56 PM
Paste table from excel to word Stephen Excel Worksheet Functions 0 January 22nd 05 11:15 AM
HELP: Access table linked to Excel - calculated fields? K Zox Excel Worksheet Functions 3 November 12th 04 08:18 AM


All times are GMT +1. The time now is 10:50 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"