 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Linking Worksheets
I have a workbook with 10 worksheets. I would like to link on worksheet to a Word document so that when I update this particula worksheet the document updates as well. I tried to do Insert Object but it only allows me to select a file. I there a way to take just one worksheet in a workbook. Also, th worksheet has a graph included. Thank -- Message posted from http://www.ExcelForum.com Dah, Copy the Excel stuff, and use Paste Special in Word. Choose Paste link. There are different ways to paste, depending on what you want in the Word document.  SignatureEarl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- > I have a workbook with 10 worksheets. I would like to link one > worksheet to a Word document so that when I update this particular [quoted text clipped - 8 lines] > --- > Message posted from http://www.ExcelForum.com/ Earl's response doesn't work in Excel 2000 (I don't know about the othe versions) because there is no Paste Special in Word. Instead, in Word, select Insert/File (instead of Object), change th file type (drop down list at bottom to Excel) and find your Excel file In 2000 anyway, you then get a prompt to either select the entir workbook or a specific worksheet. That's it -- Message posted from http://www.ExcelForum.com WM, I don't have Word 2000 here, but I have Word 97 and Word 2002. Both have Edit - Paste special. I'm willing to bet some long odds that Word 2000 has it too. :) SignatureEarl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- > Earl's response doesn't work in Excel 2000 (I don't know about the other > versions) because there is no Paste Special in Word. [quoted text clipped - 6 lines] > --- > Message posted from http://www.ExcelForum.com/ Thanks. Using Insert/File instead of Object works -- Message posted from http://www.ExcelForum.com I'm glad I didn't take the bet, Earl. You are right, of course. I kee forgetting that the toolbar menus only display the actively use choices unless you click on the arrow at the bottom (or just wait). I stand corrected -- Message posted from http://www.ExcelForum.com I don't find this very friendly, so I've turned it off. Tools|Customize|Options Tab| I've checked the "always show full menus" checkbox. > I'm glad I didn't take the bet, Earl. You are right, of course. I keep > forgetting that the toolbar menus only display the actively used [quoted text clipped - 4 lines] > --- > Message posted from http://www.ExcelForum.com/ SignatureDave Peterson ec35720@msn.com Dave, Friendly? I think it's downright counterproductive even for the folks for whom it's intended -- the beginners. With all these antics, I think Microsoft has had actually steadily made this stuff more confusing for the beginners. I see it in the problems I see users have, and the questions I hear. SignatureEarl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- > I don't find this very friendly, so I've turned it off. > [quoted text clipped - 9 lines] > > --- > > Message posted from http://www.ExcelForum.com/ Hear, Hear! The eay the shortened menus work, the actual items shown keep changing based upon use! Another irritation is the default of putting the Standard and Formmating toolbars on one row. How long do you think a begininner will find out how to turn off that "feature" on their own? Stephen Rasey Houston > Dave, > [quoted text clipped - 7 lines] > > Tools|Customize|Options Tab| > > I've checked the "always show full menus" checkbox. When I walk by someone's desk and I see these things, I change them the way I like. If they object (very infrequently), I'll change it back. But a lot of people with whom I work would be confused. Me--I'm just irritated for having to wait/not find icons quickly. > Hear, Hear! > [quoted text clipped - 24 lines] > > > Tools|Customize|Options Tab| > > > I've checked the "always show full menus" checkbox. SignatureDave Peterson ec35720@msn.com RE: When I walk by someone's desk and I see these things, I change them the way I like. Hmmm, IMO that's rather presumptuous. It would be polite to offer to help, not help yourself. If they object (very infrequently), I'll change it back. > RE: When I walk by someone's desk and I see these things, I change them > the way I [quoted text clipped - 6 lines] > Excel Templates, Training, Add-ins & Business Software Galore! > Free Excel Forum http://www.ozgrid.com/forum *** SignatureDave Peterson ec35720@msn.com I usually get "Thank You", because they are (were) completely unaware of the possibility, or the existence, of the "better" config. SignatureRegards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- If they object (very infrequently), I'll change it back. Dave Hawley wrote: > RE: When I walk by someone's desk and I see these things, I change them > the way I [quoted text clipped - 6 lines] > Excel Templates, Training, Add-ins & Business Software Galore! > Free Excel Forum http://www.ozgrid.com/forum *** SignatureDave Peterson ec35720@msn.com In fact, I got through the tools|options tabs changing them to what I like, too. I agree with you RD that a lot of users (most) don't ever look to see what could/should be changed. > I usually get "Thank You", because they are (were) completely unaware of the > possibility, or the existence, of the "better" config. [quoted text clipped - 27 lines] > Dave Peterson > ec35720@msn.com SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.