Fix: Charts Not Updating in Word

Le problème

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.

Solution rapide

Mettez à jour linked chart immediately:

1. Cliquez avec le bouton droit the chart in Word
2. Sélectionnez Mettez à jour Link (if this option s’affiche, it’s a linked chart)
3. The chart refreshes with current data from Excel
4. Done

If you don’t see “Mettez à jour Link” option, it’s an embedded chart (data is in Word, not linked to Excel). Continuez to Solution étape par étape.

Solution étape par étape

Step 1: Understand Linked vs. Embedded Graphiques

Different fixes apply to each type.

1. Cliquez avec le bouton droit the chart in your Word document
2. If you see “Mettez à jour Link,” it’s linked to an external Excel file
3. If you see “Édition Data” or “Édition Graphique,” 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 Graphiques (Links to Excel)

If your chart is linked and not updating:

1. Cliquez avec le bouton droit the chart
2. Sélectionnez Édition Link or Links (or go to Fichier > Info > Édition Links to Fichiers)
3. In the Links dialog, find your chart’s linked Excel file
4. Cliquez Mettez à jour Maintenant 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. Cliquez OK

The chart should now display current Excel data.

Step 3: Manually Actualisez the Link

Force Word to check for updated data.

1. Cliquez avec le bouton droit the chart
2. Sélectionnez Mettez à jour Link
3. Alternatively, go to Fichier > Info and look for Édition Links to Fichiers
4. Sélectionnez your linked chart data
5. Cliquez Mettez à jour Maintenant
6. Graphique refreshes

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

Step 4: Édition Embedded Graphique Data Directly

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

1. Double-cliquez the chart
2. The chart enters edit mode (borders around it change)
3. Cliquez avec le bouton droit within the chart
4. Sélectionnez Édition Data
5. A small table s’affiche showing the chart data
6. Édition the numbers and labels in this table
7. Graphique 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. Cliquez avec le bouton droit the chart
2. Sélectionnez Édition Link or go to Fichier > Info > Édition Links to Fichiers
3. Sélectionnez the chart link
4. Cliquez Break Link
5. Graphique is now embedded (no longer updates from Excel, but data is saved in Word)

To link an embedded chart:

1. Supprimez the embedded chart
2. Allez à Insérer > Graphique or Insérer > Object > Create from Fichier
3. Browse to your Excel file
4. Vérifiez “Link to file” (don’t check “Display as icon” if you want to see data)
5. Cliquez OK
6. Graphique now linked to Excel

Step 6: Vérifiez if Excel Fichier Still Exists

Linked charts break if Excel file is moved or deleted.

1. Cliquez avec le bouton droit the chart
2. Sélectionnez Édition Link or go to Fichier > Info > Édition Links to Fichiers
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)
   • Cliquez Change Source in Links dialog
   • Navigate to the actual file location
   • Cliquez OK

Step 7: Mettez à jour Excel Fichier and Manually Actualisez

1. Open the Excel file separately
2. Mettez à jour the data
3. Save the Excel file
4. Return to Word
5. Cliquez avec le bouton droit chart
6. Sélectionnez Mettez à jour Link
7. Graphique now reflects the new Excel data

Step 8: Supprimez and Reinsert Graphique as Linked

If chart won’t update despite being linked:

1. Cliquez avec le bouton droit the chart and delete it
2. Allez à Insérer > Graphique
3. Sélectionnez From Fichier or Object
4. Browse to your Excel file
5. Sélectionnez the file and click Open
6. A dialog s’affiche asking whether to link or embed
7. Vérifiez “Link to file” for linked chart
8. Uncheck “Display as icon” if you want to see data
9. Cliquez OK
10. Graphique reinserts and should update properly

Step 9: Verify Excel Range is Correct

If data is in Excel but chart uses wrong range:

1. Double-cliquez chart
2. Cliquez avec le bouton droit and select Édition Data
3. The data table shows what’s being charted
4. If data looks wrong, you may need to:
   • Supprimez this chart
   • Allez à Excel and manually create chart there
   • Copiez that chart from Excel
   • Collez it into Word
   • This is more reliable than Insérer > Graphique

Step 10: Activez Automatic Link Mettez à jours

Some Word versions allow auto-update of links.

1. Allez à Fichier > Info > Édition Links to Fichiers
2. In the Links dialog, select your chart link
3. Recherchez an “Automatic” checkbox or “Mettez à jour Method” option
4. If present, ensure “Automatic” is checked
5. Cliquez OK
6. Maintenant the chart updates automatically when you open the Word document

Pourquoi cela se produit

1. Embedded instead of linked — Graphique is copy of data, not link to source
2. Excel file moved — Link breaks if source file location changes
3. Manual edits in Word — Éditioning data in Word breaks link to Excel
4. Copiez/paste instead of insert — Collezd charts are embedded, not linked
5. Excel not open — Some charts only update if Excel is running
6. Fichier 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

Comment l’éviter

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. Mettez à jour links before sharing — Cliquez avec le bouton droit > Mettez à jour 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

Toujours pas de résultat ? Solutions alternatives

1. Recreate chart in Excel — Supprimez Word chart, create new chart in Excel, copy/paste to Word
2. Convert to image — Copiez chart, Collez 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 — Insérer > Graphique > use Word’s native chart tool instead of Excel
8. Contact Microsoft Support — For persistent linking issues, get technical support

Points clés

• Cliquez avec le bouton droit chart > “Mettez à jour Link” for linked charts
• Double-cliquez chart > “Édition Data” for embedded charts
• Linked charts pull data from Excel; embedded charts contain data in Word
• If Excel file moves, update link location (Fichier > Info > Édition Links to Fichiers)
• 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