Linked Excel Worksheet problem!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All

I have read over and tried the following article, without complete success: Microsoft Knowledge Base Article – 185315 (WD97: How to Change an Existing Linked Excel Object).

I am trying to add an additional column to a paste-linked worksheet in Word 97. By changing the range of the linked field code, I have tried to add additional rows (this works, removed columns (this worked), and tried adding a column (DIDN’T work properly). You can add a couple of columns, but this depends on the number of columns originally paste-linked. I paste-linked 10 columns and it would not allow me to add any more, but it would if I originally paste-linked 2!

I have tried editing the Excel link as well and manipulating the range link, but this too without success.

Can anyone advise me how I can add as many columns as desired?

Thanks again!

Alastair MacFarlane
 
Hi Alastair,

Try opening up the Excel workbook, selecting the new source range and
pasting it back into Word as a link. If that works, which it should, you can
safely delete the old copy.

Cheers


Alastair MacFarlane said:
Dear All

I have read over and tried the following article, without complete
Click to expand...
success: Microsoft Knowledge Base Article - 185315 (WD97: How to Change an
Existing Linked Excel Object).
I am trying to add an additional column to a paste-linked worksheet in
Click to expand...
Word 97. By changing the range of the linked field code, I have tried to add
additional rows (this works, removed columns (this worked), and tried adding
a column (DIDN'T work properly). You can add a couple of columns, but this
depends on the number of columns originally paste-linked. I paste-linked 10
columns and it would not allow me to add any more, but it would if I
originally paste-linked 2!
I have tried editing the Excel link as well and manipulating the range
Click to expand...
link, but this too without success.
 
Back
Top