Excel object in Word, change visible cells

[beilsma]

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.

 

[CyberTaz]

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

 

[AndyO]

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