🚀 go-pugleaf

cleve@darkwing.uoregon.edu (Craig Leve) wrote:

>I've been working with documents that were originally created in Word 5.1
>for the Mac and had embedded Excel spreadsheets in them.  I've upgraded to
>Microsoft Office for the Mac (so am using Excel 5 and Word 6 for the Mac)
>and have been experiencing problems where I had none before.

>When I double click on the spreadsheet in the Word document, it does bring
>up Excel successfully.  However, I seem utterly unable to control the
>number of cells which are displayed on the embedded sheet.  No matter how
>I change the view window in Excel, I get the same result on the embedded
>document.  In addition, if I close the Word document and then reopen it
>later, ALL of the embedded spreadsheets are changed to a hugely different
>scale (for instance 385% width).  Have others had similar problems?  Does
>anyone have any suggestions for this?  Please use email if appropriate to
>reply.  Thanks.

>-- 
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Craig Leve, M.S.                          Early Intervention Program
>Voice: H (503) 465-1351                    5253 University of Oregon
>       W (503) 346-2638                    Eugene, Oregon 97405-5253
>FAX:     (503) 346-5639
>WWW: http://darkwing.uoregon.edu/~cleve
>Email: cleve@darkwing.uoregon.edu
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Craig,

In Word 6 and Excel 5, we default to a mode called "In-Place", so you
would need to do the resizing of the area to be displayed once you are
in that mode (right after you've double-clicked and Excel launches and
you can then edit the formulas/text). If you drag any of the handles
in or out, the area shown in Word (that is, once you click outside of
the "excel" area) will be changed.

As far as the enlarging problem goes, this is a known problem when you
edit Excel objects with certain printer drivers. I've included the
Microsoft Knowledge Base article that explains this problem and its
workaround.

David Carson
Microsoft Office Testing


Embedded Excel Objects Become Enormous in Word

--------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Office for the Macintosh, versions 4.2 and 4.2.1
 - Microsoft Word for the Macintosh, versions 6.0 and 6.0.1
 - Microsoft Excel for the Macintosh, versions 5.0

--------------------------------------------------------------------

SYMPTOMS
========

In Microsoft Word 6.0, Excel objects embedded in Word may display at
many times the expected size. An object that started in Excel will be
multiplied roughly four times in size.

CAUSE
=====

This is caused by an apparent incompatibility between Word and Excel
and the family of Apple Macintosh printer drivers that encompass the
LaserWriter 300 driver, the LaserWriter Select 300 driver and the
StyleWriter II driver. 

This has been tested with several other printer drivers and no
problems were found beyond the ones noted.

RESOLUTION
==========

This problem can be worked around by selecting any other printer
driver or the LaserWriter (any version) driver in the Chooser and
embedding the object and then changing back to the original printer
driver to print. The resulting object should be sized appropriately. 

Also, if this workaround is used, you would want to disable the option
that updates fields on print. To do this:

1. From the Tools menu, select Options. Click the Print tab.

2. Ensure that Update Fields under Printing Options is disabled (not
checked).

3. Click OK.

Alternatively, Paste Linking the information from Excel as Formatted
Text would work without changing the printer driver.

STATUS
======

Microsoft is researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.