Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2021, 06:23 AM
d7k d7k is offline Copy paste chart from MS Excel slows down MS Word Windows 10 Copy paste chart from MS Excel slows down MS Word Office 2013
Novice
Copy paste chart from MS Excel slows down MS Word
 
Join Date: May 2021
Posts: 1
d7k is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-04-2021, 02:15 PM
macropod's Avatar
macropod macropod is offline Copy paste chart from MS Excel slows down MS Word Windows 10 Copy paste chart from MS Excel slows down MS Word Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,213
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
Reply

Tags
word. chart. slow

Thread Tools
Display Modes


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 chart from MS Excel slows down MS Word Copy & Paste Word Doc from Excel VBA RMerckling Excel Programming 4 04-18-2018 03:57 PM
Copy paste chart from MS Excel slows down MS Word Copy/paste from Excel to Word problems! mross127 Word 10 08-16-2017 04:41 PM
Copy paste chart from MS Excel slows down MS Word 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft