Locked aspect ratio not staying locked in Word 2007

[brandie]

I am working with Word 2007 and Excel 2007 on Windows XP. If I "paste
special" a linked Excel Worksheet object and choose "lock aspect ratio", the
aspect ratio does not stay "locked" when I update the links. For example,
I've pasted something in at 50% & 50% of original height. (Usually I've had
to resize it from the original size that Word chose.) When I save, close,
then reopen the document, I find that the ratios are now something like 47% &
50%. This causes the charts to be skewed.

Has anyone else seen this or able to find a workaround?

 

[Cindy M.]

Hi =?Utf-8?B?YnJhbmRpZQ==?=,

I am working with Word 2007 and Excel 2007 on Windows XP. If I "paste
special" a linked Excel Worksheet object and choose "lock aspect ratio", the
aspect ratio does not stay "locked" when I update the links. For example,
I've pasted something in at 50% & 50% of original height. (Usually I've had
to resize it from the original size that Word chose.) When I save, close,
then reopen the document, I find that the ratios are now something like 47% &
50%. This causes the charts to be skewed.

Has anyone else seen this or able to find a workaround?

I've seen this in the last few versions of Word. If you don't change that
praticular setting, does it make any difference?

In a document where this has happened, press Alt+F9 to view the field code. What
do you get between the { field brackets }?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail