 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Word / October 2005Excel object in Word, change visible cells
I inserted an Excel object in a Word document. The cells A1 to D10 are visible in the Word document. How do I change this, so that the cells A1 to --for example-- D20 become visible? To do this in Word for Windows, you double click on the object. Then you can drag the boundary and make the object bigger or smaller. How to do this in Word for Mac? If I double click on the object, the worksheet is opened in Excel and the contents can be edited. However, I'm unable to set which cells are visible in the Word document. If I single click on the object, drag the boundary and make the object bigger, the number of visible cells does not change. Any help would be appreciated. Thanks in advance. Unfortunately, OLE is implemented differently in MacOffice than WinOffice. It appears that changing the size of the object requires that it be based on a Link to an existing Workbook file or else be re-created/re-inserted after changes are made. Regards |:>) On 10/23/05 6:02 PM, in article 1130104963.587559.98090@f14g2000cwb.googlegroups.com, "beilsma@gmail.com" > I inserted an Excel object in a Word document. > The cells A1 to D10 are visible in the Word document. [quoted text clipped - 16 lines] > Any help would be appreciated. > Thanks in advance. Actually, the only way that I have been successful in changing the size of an embedded spreadsheet is by copying and pasting in the Excel range as a link, then manually changing the cell reference via the Change Source option in the Links Dialog box from Edit>Links. I tried doing that with a spreadsheet that I created from within the Word document - that is, creating it and then saving it as a linked document - but Excel won't let you Save at that point - only lets you save a copy which is not the actual linked document. Andy |
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
|
©2009 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.