Linked Excel Worksheet problem!

[Alastair MacFarlane]

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

 

[macropod]

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

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.