Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Rev Anderson Rev Anderson is offline
external usenet poster
 
Posts: 3
Default Limited Linking of Excel Spreadsheets in Word?

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
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Limited Linking of Excel Spreadsheets in Word?

Hi ?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 :-)

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Rev Anderson Rev Anderson is offline
external usenet poster
 
Posts: 3
Default Limited Linking of Excel Spreadsheets in Word?

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." wrote:

Hi ?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 :-)


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Limited Linking of Excel Spreadsheets in Word?

Hi ?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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why dont MS just f**king re-write Word from scratch? Its dogsh*t Word Hater Microsoft Word Help 33 May 5th 23 02:52 PM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Change paper size; Word changes to invalid margins OhioTech New Users 10 July 6th 06 02:00 PM
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 10:16 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


All times are GMT +1. The time now is 08:43 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"