Fix: Charts Not Updating in Word

The Problem

Your Word document contains a chart created from Excel data, but when you update the Excel file, the chart in Word doesn’t change. The chart shows outdated numbers from months ago. Manually changing the chart in Word doesn’t sync back to Excel. The link between Excel and Word is broken. You want the chart to always reflect current Excel data.

Quick Fix

Update linked chart immediately:

1. Right-click the chart in Word
2. Select Update Link (if this option appears, it’s a linked chart)
3. The chart refreshes with current data from Excel
4. Done

If you don’t see “Update Link” option, it’s an embedded chart (data is in Word, not linked to Excel). Proceed to Step-by-Step Solution.

Step-by-Step Solution

Step 1: Understand Linked vs. Embedded Charts

Different fixes apply to each type.

1. Right-click the chart in your Word document
2. If you see “Update Link,” it’s linked to an external Excel file
3. If you see “Edit Data” or “Edit Chart,” it’s embedded in Word

Linked charts: Data lives in Excel file; Word shows preview Embedded charts: Data is copied into Word; independent from Excel

Step 2: Fix Linked Charts (Links to Excel)

If your chart is linked and not updating:

1. Right-click the chart
2. Select Edit Link or Links (or go to File > Info > Edit Links to Files)
3. In the Links dialog, find your chart’s linked Excel file
4. Click Update Now to refresh immediately
5. If you see error like “file not found,” click Change Source and navigate to where the Excel file is now
6. Click OK

The chart should now display current Excel data.

Step 3: Manually Refresh the Link

Force Word to check for updated data.

1. Right-click the chart
2. Select Update Link
3. Alternatively, go to File > Info and look for Edit Links to Files
4. Select your linked chart data
5. Click Update Now
6. Chart refreshes

Do this whenever you’ve updated the source Excel file.

Step 4: Edit Embedded Chart Data Directly

If chart is embedded (not linked), edit the data within Word.

1. Double-click the chart
2. The chart enters edit mode (borders around it change)
3. Right-click within the chart
4. Select Edit Data
5. A small table appears showing the chart data
6. Edit the numbers and labels in this table
7. Chart updates immediately as you change data
8. When done, click outside the chart to exit edit mode

Step 5: Change Linked to Embedded (or Vice Versa)

If you want to switch between linked and embedded:

To embed a linked chart:

1. Right-click the chart
2. Select Edit Link or go to File > Info > Edit Links to Files
3. Select the chart link
4. Click Break Link
5. Chart is now embedded (no longer updates from Excel, but data is saved in Word)

To link an embedded chart:

1. Delete the embedded chart
2. Go to Insert > Chart or Insert > Object > Create from File
3. Browse to your Excel file
4. Check “Link to file” (don’t check “Display as icon” if you want to see data)
5. Click OK
6. Chart now linked to Excel

Step 6: Check if Excel File Still Exists

Linked charts break if Excel file is moved or deleted.

1. Right-click the chart
2. Select Edit Link or go to File > Info > Edit Links to Files
3. Look at the “Source” field to see where Word thinks the Excel file is
4. Navigate to that location to verify the file exists
5. If file not found:
   • Locate your Excel file (search for it)
   • Click Change Source in Links dialog
   • Navigate to the actual file location
   • Click OK

Step 7: Update Excel File and Manually Refresh

1. Open the Excel file separately
2. Update the data
3. Save the Excel file
4. Return to Word
5. Right-click chart
6. Select Update Link
7. Chart now reflects the new Excel data

Step 8: Delete and Reinsert Chart as Linked

If chart won’t update despite being linked:

1. Right-click the chart and delete it
2. Go to Insert > Chart
3. Select From File or Object
4. Browse to your Excel file
5. Select the file and click Open
6. A dialog appears asking whether to link or embed
7. Check “Link to file” for linked chart
8. Uncheck “Display as icon” if you want to see data
9. Click OK
10. Chart reinserts and should update properly

Step 9: Verify Excel Range is Correct

If data is in Excel but chart uses wrong range:

1. Double-click chart
2. Right-click and select Edit Data
3. The data table shows what’s being charted
4. If data looks wrong, you may need to:
   • Delete this chart
   • Go to Excel and manually create chart there
   • Copy that chart from Excel
   • Paste it into Word
   • This is more reliable than Insert > Chart

Step 10: Enable Automatic Link Updates

Some Word versions allow auto-update of links.

1. Go to File > Info > Edit Links to Files
2. In the Links dialog, select your chart link
3. Look for an “Automatic” checkbox or “Update Method” option
4. If present, ensure “Automatic” is checked
5. Click OK
6. Now the chart updates automatically when you open the Word document

Why This Happens

1. Embedded instead of linked — Chart is copy of data, not link to source
2. Excel file moved — Link breaks if source file location changes
3. Manual edits in Word — Editing data in Word breaks link to Excel
4. Copy/paste instead of insert — Pasted charts are embedded, not linked
5. Excel not open — Some charts only update if Excel is running
6. File permissions — Excel file read-only or restricted
7. Corrupted link — Connection between Word and Excel damaged
8. Different computer — Linked file path valid on your computer but not shared computers

How to Prevent It

1. Relink after moving files — If you move Excel file, update the link in Word
2. Prefer linking for dynamic data — Use links if Excel is updated frequently
3. Use embedded for static charts — If data won’t change, embed for simplicity
4. Test links before sharing document — Verify charts update before sending
5. Keep Excel file in consistent location — Don’t move source files often
6. Update links before sharing — Right-click > Update Link before sharing Word
7. Use absolute paths — When possible, link to files on network shared drives
8. Document the link — Make note of which Excel file a chart is linked to

Still Not Working? Alternative Solutions

1. Recreate chart in Excel — Delete Word chart, create new chart in Excel, copy/paste to Word
2. Convert to image — Copy chart, Paste Special > As Picture for static snapshot
3. Use Power Query — Advanced: Power Query can pull data into Word indirectly
4. Send Excel with document — Include Excel file with Word so links work on any computer
5. Use SharePoint link — Store Excel on SharePoint, link from there for reliable access
6. Break link, manually update — If linking doesn’t work, break link and manually update chart data
7. Use Word’s built-in chart — Insert > Chart > use Word’s native chart tool instead of Excel
8. Contact Microsoft Support — For persistent linking issues, get technical support

Key Takeaways

• Right-click chart > “Update Link” for linked charts
• Double-click chart > “Edit Data” for embedded charts
• Linked charts pull data from Excel; embedded charts contain data in Word
• If Excel file moves, update link location (File > Info > Edit Links to Files)
• Breaking a link converts it to embedded; you lose automatic updates
• Test links work before sharing document with others
• Create charts in Excel, link to them from Word for best reliability
• Updating embedded data is easy but requires manual Excel-to-Word process