Limited Linking of Excel Spreadsheets in Word?

[Guest]

In Office 2000 I was able to create and insert linked Excel spreadsheets of
all different sizes with a catalog pricing update system into a word document.

In Office 2003 when I link a simple speadsheet with only 30 rows and 20
columns into a Word document all I get is the first 10 rows and about 6
columns. Even if I try to expand the excel window all it does is make the
displayed text larger to fill the display area.

Why can't I see the rest of the rows?

I have checked margins, page set-up and other settings but I am unable to do
a Link to show all of the spreadsheet.

Thanks

 

[Cindy M.]

Hi =?Utf-8?B?UmV2IEFuZGVyc29u?=,

In Office 2000 I was able to create and insert linked Excel spreadsheets of
all different sizes with a catalog pricing update system into a word document.

In Office 2003 when I link a simple speadsheet with only 30 rows and 20
columns into a Word document all I get is the first 10 rows and about 6
columns. Even if I try to expand the excel window all it does is make the
displayed text larger to fill the display area.

Why can't I see the rest of the rows?

How about if you double-click the sheet (so that you see the Excel commands in
the menus), then drag the sides of the window? (Be careful to not click in the
document, which would return you to Word mode.)

If that doesn't help, please list the commands you use to insert the linked
spreadsheets.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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

 

[Guest]

I had given up on Office 2003 and actually went to an old computer with
Office 2000 to continue my work.

I played with the Office 2003 later and after I did a copy and paste as an
HTML object I was able to do a copy and paste as a special Excel object which
now shows all of the rows and columns. Now the Office 2003 is doing what it
should have done at the start. I'm not sure what was stopping it before?

 

[Cindy M.]

Hi =?Utf-8?B?UmV2IEFuZGVyc29u?=,

I played with the Office 2003 later and after I did a copy and paste as an
HTML object I was able to do a copy and paste as a special Excel object which
now shows all of the rows and columns. Now the Office 2003 is doing what it
should have done at the start. I'm not sure what was stopping it before?

Hard to say. Maybe it was just a "glitch" that got straightened out when Windows
was restarted. Glad things are working now, in any case

Cindy Meister