Excel to Word : Paste special>Paste Link> Excel Chart Obj doesn't

Excel to Word : Paste special>Paste Link> Excel Chart Obj doesn't

Post by TWFrZWRvb » Thu, 14 Jan 2010 05:56:02


When I copy a chart from an Excell 2007 file and
paste it as: Paste Special > Paste link > Microsoft Office Excel Chart Object
I get a blank white picture (with gridlines in middle and a red (x) in the
top left corner). It does not show correctly. However, the link is working
correctly.

after troubleshooting:

I noticed that if I paste the same chart with 2700 rows of data the chart
shows properly. But when I go above the 2700 rows of data the chart does not
display properly.

when I pasted the chart with the original 47000 rows of data it was not
diplaying properly; however, i started to delete rows, and when I got to 2700
rows, and updated the link (right click on chart and 'Update Link' in Word)
the chart updated properly.

I only have three columns of data graphed (X-Y-Y) , in case you want to know
the amount of data.

Seeing that the problem lies with too much data; Is there a work-around this
problem? Is this a known issue? is the problem with Excel or Word?
What can I do?

Thank you in advance for all of you help.

Comp Specs:
OS: Win XP pro SP3; 3GHz; 3G RAM;
Excel 2007 & Word 2007
 
 
 

1. Excel => Paste Link => Word

2. Excel Automation - Chart Performance > Paste Chart As Link?

Matt:

Are you pasting your charts into PowerPoint as Links? If so, HOW? I also
wrote a table and chart exporter from Excel to PPT, but I couldn't find a
way to PasteSpecial a chart as a link. Someone please tell me if it's
impossible.

Bruce Cooley




: Hello,
:
: I have a VB application that I have written that generates
: charts and tables in Excel, and pastes them into
: PowerPoint. I have found that the largest performance
: bottleneck seems to be with the chart and with the table
: rendering in excel.
:
: Does anyone have any performance tips for automating excel?
:
: Thanks
: Matt
:

3. Excel Worksheet ---> PPT - paste (picture) vs. paste link + ungrou

4. Paste special -->Paste & Link and update picture files!

5. Paste Special => Paste Link.... :(

6. Copy and paste Excel chart in Word --> font compresses

7. Paste Special - Paste Link - MS Excel Worksheet Object

8. Excel 2003 --> Copying a formula to Paste Special into column cell

9. Excel 2003 --> Copying a formula to Paste Special into column

10. Special pasting Charts from Excel to Word (2007 versions)

11. Excel Work Book Copied Into Word With Paste Special, Excel Workboo

12. Bugs in Word 2007 [Paste Special Excel Chart]

13. What does Insert>Name>Label & Insert>Name>Paste do?

14. problem: when paste => validations lost => excel corrupted !

15. Paste Special Excel Charts In Word Doesn't Work Right?