Change Excel Linked Worksheet

  • Thread starter Thread starter Alastair MacFarlane
  • Start date Start date
A

Alastair MacFarlane

Dear All

I have tried the follow Microsoft Article 185315 (How to
change an Existing Linked Excel Object) without much
success.

I have paste linked an excel.8 worksheet (Excel 97/Word97)
into a word document. If I want to change either the
number of rows displayed or columns, this article
demontrates 3 ways of achieving this. The article suggests
that you change the range element of the linked
spreadsheet. If I change the row element of the range
object it works perfectly, however, If I add columns,
these additional columns are not displayed, and if I
reduce the number of columns, they revised number of
columns ARE displayed (but no more than the original paste-
linked area).

Can anyone suggest what I am doing wrong. How can you
increase the number of columns displayed in a past-linked
excel worksheet?

Thanks again!

Alastair MacFarlane
 
Hi Alastair,

Your best bet would be

- remove the "float over text" formatting

- press Alt+F9 to see the field codes

- edit the field code to use the correct number of rows and
columns

Note 1: there is a maximum number of rows and columns Word 97
will be able to display, even if more would fit on the page

Note 2: if the content will be changing often, assign a RANGE
NAME to the cells in Excel and use this instead of the
R#C#:R#C# cell reference in the LINK field.
I have paste linked an excel.8 worksheet (Excel 97/Word97)
into a word document. If I want to change either the
number of rows displayed or columns, this article
demontrates 3 ways of achieving this. The article suggests
that you change the range element of the linked
spreadsheet. If I change the row element of the range
object it works perfectly, however, If I add columns,
these additional columns are not displayed, and if I
reduce the number of columns, they revised number of
columns ARE displayed (but no more than the original paste-
linked area).

Can anyone suggest what I am doing wrong. How can you
increase the number of columns displayed in a past-linked
excel worksheet?
Click to expand...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)
 
Back
Top