A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help! Can I eliminate scaling when I paste Excel tables and charts into Word?



 
 
Thread Tools Display Modes
  #1  
Old September 12th, 2006, 04:36 PM posted to microsoft.public.word.conversions,microsoft.public.word.customization.menustoolbars,microsoft.public.word.tables
DarrylR
external usenet poster
 
Posts: 6
Default Help! Can I eliminate scaling when I paste Excel tables and charts into Word?

I'm trying to determine what causes Word to resize Excel tables and charts
that are pasted into a document using Edit - Paste Special.

I am pasting charts using the following process:
1. Select a chart object in Excel (one that's embedded on a worksheet, not
on a separate chart sheet) by clicking the chart area.
2. Select Edit - Copy.
3. Create a blank Word document, and paste the chart into it using
Edit -Paste Special -As Microsoft Excel Chart Object.

And I am pasting tables using the following process:
1. Highlight a range of cells in Excel (using Edit - Goto - named
range).
2. Select Edit - Copy.
3. Create a blank Word document, and paste the range into it using
Edit -Paste Special -As Microsoft Excel Worksheet Object.

When I perform the steps above on my machine, charts are not scaled at all
(which is what I would expect/hope). Tables are scaled, however, such that
their height is 97% of the original height, and their width is 105% of the
original width. On another colleague's machine, charts and tables are both
scaled to 85% of their original size. And on yet another colleague's
machine, neither charts nor tables are scaled. All of our machines are
running Word 2003 SP2 (build 11.6568.6568) under Windows 2000 Professional
SP4.

I tried turning off "Adjust formatting when pasting from Microsoft Excel"
(Tools - Options - Edit - Settings...), which had no effect. I also tried
turning off "Smart cut and paste" entirely. Nothing seems to affect the
behavior. Is there some setting that I'm missing? Is there a default paste
size/scale stored somewhere?

Regards,
Darryl R.


  #2  
Old September 12th, 2006, 10:19 PM posted to microsoft.public.word.conversions,microsoft.public.word.customization.menustoolbars,microsoft.public.word.tables
DarrylR
external usenet poster
 
Posts: 6
Default Help! Can I eliminate scaling when I paste Excel tables and charts into Word?

Believe it or not, Copy/Paste behavior is affected by the default printer
selected on the machine. I discovered that the most significant size
reduction occurs when "Acrobat PDFWriter" is selected as the default
printer. The scaling percentage varies depending upon the default printer
selected. The only printer driver that I've found that doesn't result in
scaling is an old HP 5P/MP.

Regards,
Darryl R.

"DarrylR" wrote in message
...
I'm trying to determine what causes Word to resize Excel tables and charts
that are pasted into a document using Edit - Paste Special.

I am pasting charts using the following process:
1. Select a chart object in Excel (one that's embedded on a worksheet, not
on a separate chart sheet) by clicking the chart area.
2. Select Edit - Copy.
3. Create a blank Word document, and paste the chart into it using
Edit -Paste Special -As Microsoft Excel Chart Object.

And I am pasting tables using the following process:
1. Highlight a range of cells in Excel (using Edit - Goto - named
range).
2. Select Edit - Copy.
3. Create a blank Word document, and paste the range into it using
Edit -Paste Special -As Microsoft Excel Worksheet Object.

When I perform the steps above on my machine, charts are not scaled at all
(which is what I would expect/hope). Tables are scaled, however, such that
their height is 97% of the original height, and their width is 105% of the
original width. On another colleague's machine, charts and tables are both
scaled to 85% of their original size. And on yet another colleague's
machine, neither charts nor tables are scaled. All of our machines are
running Word 2003 SP2 (build 11.6568.6568) under Windows 2000 Professional
SP4.

I tried turning off "Adjust formatting when pasting from Microsoft Excel"
(Tools - Options - Edit - Settings...), which had no effect. I also

tried
turning off "Smart cut and paste" entirely. Nothing seems to affect the
behavior. Is there some setting that I'm missing? Is there a default paste
size/scale stored somewhere?

Regards,
Darryl R.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.