|
#1
|
|||
|
|||
Copy paste chart from MS Excel slows down MS Word
Hi!
I have problem with my MS Word 2013. I created a chart from a large amount of data in excel. The X axis and the Y axis have about 50,000 data. When I copy and paste the graph into MS Word and want to write something while the graph is displayed on the screen, MS Word starts to run slowly. For example, when writing the word "example", it takes about 5 seconds before it appears on the screen. When I write the same word on a blank page, this problem disappears. I suspect this is a problem with the large amount of data in the chart. By saving the graph as an image, I lose the quality of the letters. I tried to save the chart to PDF and convert it to EPS file but after inserting it into MS Word the program stopped responding. Any of you have an idea or know how to paste a chart from Excel to Word without losing the quality of the chart and MS Word not running so slowly? Thanks for all your help and suggestions. Example files below. https://mega.nz/folder/QJQ0mJDK#mh89W8y_wppvarGhv6FiIQ Last edited by Charles Kenyon; 05-04-2021 at 08:37 AM. Reason: enhance readability |
#2
|
||||
|
||||
When you copy & paste a chart from Excel into Word, the underlying data also get copied as a table. Word tables are performance hogs. A multi-column 50,000 row table is bound to slow things down.
If you use Paste Special and the 'Microsoft Office Graphic Object' option, your text quality should be preserved. If you need to keep the data synchronised with Excel, use the Paste Link option, but be aware that refreshing the links may take some time.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
word. chart. slow |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Open Excel, copy & paste data & chart | Tal71 | Word VBA | 2 | 08-14-2018 08:28 PM |
Copy & Paste Word Doc from Excel VBA | RMerckling | Excel Programming | 4 | 04-18-2018 03:57 PM |
Copy/paste from Excel to Word problems! | mross127 | Word | 10 | 08-16-2017 04:41 PM |
Copy/Paste EXCEL cells as pic in WORD | A_Lau | Drawing and Graphics | 3 | 12-19-2014 06:57 AM |
copy/paste charts from excel to word | bielak01 | Excel | 0 | 04-16-2009 02:27 AM |