Ask a new question

Linked Excel 2010 graphs randomly break links or degrade in image quality

I am working on a Word 2010 document that has multiple graphs that are linked to several different Excel 2010 files. The document is prone to crashing and the links will randomly break. In addition, updating them often causes the image to reduce in quality. The link is still active, but the text and lines within the chart are blurry, as if it were pasted as a picture (windows metafile).

 

The issue is random in that some graphs that are from the same excel file (and even the same tab within the file) will break their links or become distorted, while others will not. Once a graph degards in quality, I can't get the original quality back. I have to delete the graph and re-paste a new linked graph.

 

If anyone has encountered this problem, or has a potential solution, I would greatly appreciate. I have a lot of graphs in the document that I have to update on a quarterly basis and this issue can be very time consuming.

 

 

Thank you very much,

 

Ben

Hi Ben,

 

I would need more details to assist you:

What is the file extension of the Word document? Is it a .docx or .doc file type?

What is the file extension of the Excel workbook? Is it a .xlsx or .xls file type?

 

Ensure both the files (Word document and Excel Workbook) are of the same version ie; If Word document is .docx extension then ensure that the Excel workbook is .xlsx extension.

Or if Word document is a .doc then the Excel workbook has to .xls.

If either one of the file is not corresponding, then save that file in the same format and then check if this issue occurs.

 

Let us know the results for further assistance.

Thank you.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Aravina,

 

 

Thanks for responding so quickly.  The word file is a .docx and the excel files are all .xlsx. If there is anything else that I can do, please let me know.

 

 

Thanks Again,

 

Ben

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Aravina,

 

 

Thanks for responding so quickly.  The word file is a .docx and the excel files are all .xlsx. If there is anything else that I can do, please let me know.

 

 

Thanks Again,

 

Ben


Hi Ben,

 

Thank you for the response and sorry for the delay to address this issue.

 

I would like to know if this issue occur with a particular file or any linked files?

 

You may check if there are any compatibility issues with the linking of files by doing the following:

Click on File, go to Info, Check for Issues, Compatibility.

 

You may also create a new file, link the graphs and check if the issue occurs.

 

Let us know the results for further assistance.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 362 Applies to: