Resizing Embedded Excel Worksheets in Word X.
T Farrell
the spreadsheet to insert an extra row. When I do this (by double clicking
to bring up excel, inserting the row and closing) - the view of the spead
sheet in word does not expand to show the extra row. Any attempt to
expand the embedded object using the object frame just scales the
existing view.
The embedded spreadsheet was inserted by selecting and copying in excel
and then using "past special" in word ("paste" checkbox rather then
"paste link") and pasting it as an "MS Excel Worksheet Object". The
effect is repeatable in the new document.
In Office 97, this can be done since the editing is in place and you can
expand the viewed area.
If I instead insert the object linked to the original document rather then
embedded, then I can edit the field code to change the displayed area -
but for embedded objects this information does not seem to be accessible
(the field code is just "EMBED Excel.Sheet.8..").
Other then removing the spreadsheets to an external workbook and
linking back to them, is there any way around this.
The version stuff - Office X for Mac SR1, MacOSX Version 10.2.3
Thanks
![John McGhie [MVP]'s profile photo](http://lh3.googleusercontent.com/a-/ALV-UjUUBKAjV8QW66Rah4TWGr_ASZh1CyehMN6s11i8zY3oOiau=s40-c)
John McGhie [MVP]
I have not got Excel here at the moment to try, so do this for me:
1) Use Format>Object>Size to set the Size to 100 per cent. Does that fix
it?
2) Double-click the object, add and remove a space from one of the cells,
then close it. Did that fix it?
3) The object is actually encased in a Text Box. There are two frames: one
for the object, the other for the text box.
If you click, then click again, slowly, the selection rectangle will
slightly change its appearance. When that happens, try dragging again.
It's damned difficult to get this to work: the first click selects the
object, the second click selects the frame. In Word X, it's nearly
impossible to see the difference.
Hope this helps
This responds to article <47ef56fb.03021...@posting.google.com>,
from "T Farrell" <t...@aaoepp.aao.gov.au> on 11/2/03 4:29 PM:
--
All Spam and attachments blocked by Microsoft Entourage for Mac OS X. Please
post replies to the newsgroup to maintain the thread.
John McGhie, Microsoft MVP: Word for Macintosh and Word for Windows
Consultant Technical Writer <jo...@mcghie-information.com.au>
+61 4 1209 1410; Sydney, Australia: GMT + 10 hrs
T Farrell
> Hi Terry:
>
> I have not got Excel here at the moment to try, so do this for me:
>
> 1) Use Format>Object>Size to set the Size to 100 per cent. Does that fix
> it?
No - it was already at 100%. It appears that any change to the size
here just scales the object.
>
> 2) Double-click the object, add and remove a space from one of the cells,
> then close it. Did that fix it?
No.
>
> 3) The object is actually encased in a Text Box. There are two frames: one
> for the object, the other for the text box.
>
> If you click, then click again, slowly, the selection rectangle will
> slightly change its appearance. When that happens, try dragging again.
> It's damned difficult to get this to work: the first click selects the
> object, the second click selects the frame. In Word X, it's nearly
> impossible to see the difference.
Afraid not - I don't see the change you mention. When clicking slowly
the second time it seems to move into a "drag" mode. The "Picture"
tool bar - which I think should change to
"Format Text Box" mode if I end up in a text box, does not change.
>
> Hope this helps
Thanks for the attempt.
Jim Gordon
In place editing is not quite the same in Mac and Windows versions. You may
have to save the Excel workbook after increasing the number of columns, then
delete the embedded workbook from Word and re-embed the now larger workbook.
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
Find Macintosh experts in your hometown. Join a user group:
http://www.microsoft.com/mindshare/default.asp
http://www.apple.com/usergroups/
----------
In article <47ef56fb.03021...@posting.google.com>,
musd...@gmail.com
Sadly it was possible in my windows laptop. Now in Mac it is not possible.
Any ideas?
