Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Change paper size; Word changes to invalid margins | New Users | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
Excel worksheet in Word linked text boxes | Page Layout |