Cannot resize visible area of Excel Sheet inserted into Word 2008

[sabr]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a problem which is difficult to put into words. I have inserted an Excel Spreadsheet into Word 2008 (using INSERT - OBJECT and then selecting MS Excel Sheet). However when I try to use the resizing tools, instead of showing more or less of the sheet, it just resizes the whole object (by zooming/scaling).

My problem seems to be covered in MS KB article KB894030.

Are you telling me that after 4 years (between Word 2004 and 2008) that this problem has not been fixed?

Both workarounds are useless to me as I am using a template which I need to often vary the number of rows of the sheet on.

I note that this is not a problem in Word 2007??

Does anyone know if there is a better solution/updated KB article related to this subject?

 

[John McGhie]

Yes. That's what they are saying. This has not been changed yet.

The function requires a design change, and they did not have time to do that
for Word 2008. So I am afraid there is no solution: you have to select it
in Excel at the size you want it in Word.

Maybe next version.

Cheers

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a problem which is difficult to put into words. I have inserted an
Excel Spreadsheet into Word 2008 (using INSERT - OBJECT and then selecting MS
Excel Sheet). However when I try to use the resizing tools, instead of showing
more or less of the sheet, it just resizes the whole object (by
zooming/scaling).

My problem seems to be covered in MS KB article KB894030.

Are you telling me that after 4 years (between Word 2004 and 2008) that this
problem has not been fixed?

Both workarounds are useless to me as I am using a template which I need to
often vary the number of rows of the sheet on.

I note that this is not a problem in Word 2007??

Does anyone know if there is a better solution/updated KB article related to
this subject?

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:[email protected]

 

[CyberTaz]

This complaint predates OS X Regrettably this is a restriction that
persists in Word 2008 - the Inserted Excel object is limited to 5 columns &
10 rows. Perhaps the next release will expand OLE capability but it will
definitely *not* be changed in 12.x

Copying a range of cells then using Edit> Paste Special - MS Excel Sheet
Object & replacing it as necessary is about as good as it gets.

Use Help> Send Feedback to add to the list of disgruntled users.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[sabr]

This is ridiculous. As I said, the spreadsheet is used as part of template (for accounting purposes).

Because the number of rows is variable from one document to the next, I need to vary the template each time to reflect the number of rows/amount of data needed in a particular document.

This is fast and easy in Word 2007. Unforgivable for OS X users to be plagued by this bug for at least 4 years.

 

[CyberTaz]

Sorry, but you're preaching to the choir - you're welcome to wail away here
in the ng but don't expect it to change anything. The *few* MS personnel who
*occasionally* peek in here are not the ones who make the decisions on such
matters & the overwhelming majority of us are just users of the product.

Further to my last reply - it may not have been clear: If you use the Paste
method I described to set up the template you may still be able to get what
you want. In a new doc based on the template you should be able to
double-click the object to open it in Excel. As long as the additional rows
are added/removed *within* the limits of the same range of cells the object
in the doc will expand/contract accordingly. IOW, it isn't that the finished
product won't work as you wish, it's just that the method needed to
establish the object in your template is different than what you expect.
Replacing the object in each new document would only be necessary if
additional rows are added at the *bottom* of the existing range.

Another option: For what you're purpose, would it be practical to consider
using a Word Table with formulas rather than an Excel object?

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[sabr]

Thanks for the reply CyberTaz. I will give it a go with your first suggestion when I get some time. I could add and subtract rows from within the cell range as you said, and will see if that automatically expands and contracts.