R
Ryan
Hello,
I am having a problem when pasting an Excel cell range as an linked worksheet:
1. Select and copy range in Excel.
2. In Word, Paste special > Paste link > Microsoft Office Excel Worksheet
Object
When the object is pasted, it is never the original size. The window from
Format Object > Size always displays the Height at 96 % and the Width at 108
% (sometimes the Height is 97 %). This happens if even when I start with
fresh Word and Excel files.
To get the object to 100 % and 100 %, I uncheck "Lock aspect ratio" and
"Relative to original picture size" then choose "Reset". This is the only
combination I found that worked to (usually) keep in at 100/100. (Word does
not seem to honor the "Lock" and "Relative" options even if they are checked
because I can keep them checked, hit "Reset" and see the dimensions match the
original dimension, hit "OK", go back to the Size settings, and it is at 90 %
height and 100 % width or something else.)
I know that some of the other paste options correctly paste in at 100/100,
but I need the Excel worksheet format. This is because I use the specific
minus sign character (U+2212) for negative values. "Picture (Windows
Metafile)" replaces the minus sign with a question mark and "Bitmap" makes
the text all pixelated. "Picture (Enhanced Metafile)" comes in pretty close,
but it is not available as a link. I can't use the HTML for RTF formats
because the mess-up the custom number formats I've used in Excel to align the
numbers just right (so that xx.x, x.x, -xx.x, and -x.x all are
decimal-aligned first and then centered in the cell).
I have seen suggestions for these other paste methods, but no fix for the
Excel worksheet method. Do anyone know of a solution? (I am using the 2007
versions of both programs.)
Thank you,
Ryan
I am having a problem when pasting an Excel cell range as an linked worksheet:
1. Select and copy range in Excel.
2. In Word, Paste special > Paste link > Microsoft Office Excel Worksheet
Object
When the object is pasted, it is never the original size. The window from
Format Object > Size always displays the Height at 96 % and the Width at 108
% (sometimes the Height is 97 %). This happens if even when I start with
fresh Word and Excel files.
To get the object to 100 % and 100 %, I uncheck "Lock aspect ratio" and
"Relative to original picture size" then choose "Reset". This is the only
combination I found that worked to (usually) keep in at 100/100. (Word does
not seem to honor the "Lock" and "Relative" options even if they are checked
because I can keep them checked, hit "Reset" and see the dimensions match the
original dimension, hit "OK", go back to the Size settings, and it is at 90 %
height and 100 % width or something else.)
I know that some of the other paste options correctly paste in at 100/100,
but I need the Excel worksheet format. This is because I use the specific
minus sign character (U+2212) for negative values. "Picture (Windows
Metafile)" replaces the minus sign with a question mark and "Bitmap" makes
the text all pixelated. "Picture (Enhanced Metafile)" comes in pretty close,
but it is not available as a link. I can't use the HTML for RTF formats
because the mess-up the custom number formats I've used in Excel to align the
numbers just right (so that xx.x, x.x, -xx.x, and -x.x all are
decimal-aligned first and then centered in the cell).
I have seen suggestions for these other paste methods, but no fix for the
Excel worksheet method. Do anyone know of a solution? (I am using the 2007
versions of both programs.)
Thank you,
Ryan