Fix: Charts Not Updating in Word

Проблема

Your Word документ contains a chart created from Excel data, but when you update the Excel Файл, 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.

Быстрое исправление

Update linked chart immediately:

1. Щелкните правой кнопкой мыши на 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 1: Understand Linked vs. Embedded Charts

Different fixes apply to each type.

1. Щелкните правой кнопкой мыши на chart in your Word документ
2. If you see “Update Link,” it’s linked to an external Excel Файл
3. If you see “Правка Data” or “Правка Chart,” it’s embedded in Word

Linked charts: Data lives in Excel Файл; 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. Щелкните правой кнопкой мыши на chart
2. Select Правка Link or Links (or Перейдите в Файл > Info > Правка Links to Files)
3. In the Links dialog, find your chart’s linked Excel Файл
4. Click Update Now to refresh immediately
5. If you see error like “Файл not found,” click Change источник and navigate to where the Excel Файл 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. Щелкните правой кнопкой мыши на chart
2. Select Update Link
3. Alternatively, Перейдите в Файл > Info and Найдите Правка Links to Files
4. Select your linked chart data
5. Click Update Now
6. Chart refreshes

Do this whenever you’ve updated the источник Excel Файл.

Step 4: Правка Embedded Chart Data Directly

If chart is embedded (not linked), Правка the data within Word.

1. Double-Нажмите на chart
2. The chart enters Правка mode (borders around it change)
3. Right-click within the chart
4. Select Правка Data
5. A small таблица appears showing the chart data
6. Правка the numbers and labels in this таблица
7. Chart updates immediately as you change data
8. When done, click outside the chart to exit Правка 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. Щелкните правой кнопкой мыши на chart
2. Select Правка Link or Перейдите в Файл > Info > Правка Links to Files
3. Выберите 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. Удалите embedded chart
2. Перейдите в Вставка > Chart or Вставка > Object > Create from Файл
3. Browse to your Excel Файл
4. Check “Link to Файл” (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 Файл Still Exists

Linked charts break if Excel Файл is moved or deleted.

1. Щелкните правой кнопкой мыши на chart
2. Select Правка Link or Перейдите в Файл > Info > Правка Links to Files
3. Look at the “источник” поле to see where Word thinks the Excel Файл is
4. Navigate to that location to verify the Файл exists
5. If Файл not found:
   • Locate your Excel Файл (search for it)
   • Click Change источник in Links dialog
   • Navigate to the actual Файл location
   • Click OK

Step 7: Update Excel Файл and Manually Refresh

1. Open the Excel Файл separately
2. Update the data
3. Save the Excel Файл
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. Щелкните правой кнопкой мыши на chart and delete it
2. Перейдите в Вставка > Chart
3. Select From Файл or Object
4. Browse to your Excel Файл
5. Выберите Файл and click Open
6. A dialog appears asking whether to link or embed
7. Check “Link to Файл” 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 Правка Data
3. The data таблица shows what’s being charted
4. If data looks wrong, you may need to:
   • Delete this chart
   • Перейдите в Excel and manually create chart there
   • Copy that chart from Excel
   • Paste it into Word
   • This is more reliable than Вставка > Chart

Step 10: Enable Automatic Link Updates

Some Word versions allow auto-update of links.

1. Перейдите в Файл > Info > Правка Links to Files
2. In the Links dialog, select your chart link
3. Найдите 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 документ

Почему это происходит

1. Embedded instead of linked — Chart is copy of data, not link to источник
2. Excel Файл moved — Link breaks if источник Файл location changes
3. Manual edits in Word — Editing data in Word breaks link to Excel
4. Copy/paste instead of Вставка — Pasted charts are embedded, not linked
5. Excel not open — Some charts only update if Excel is running
6. Файл permissions — Excel Файл read-only or restricted
7. Corrupted link — Connection between Word and Excel damaged
8. Different computer — Linked Файл path valid on your computer but not shared computers

Как это предотвратить

1. Relink after moving files — If you move Excel Файл, 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 документ — Verify charts update before sending
5. Keep Excel Файл in consistent location — Don’t move источник 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. документ the link — Make note of which Excel Файл a chart is linked to

Still Not Working? Альтернативные решения

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 документ — Include Excel Файл 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 — Вставка > Chart > use Word’s native chart tool instead of Excel
8. Contact Microsoft Support — For persistent linking issues, get technical support

Ключевые моменты

• Right-click chart > “Update Link” for linked charts
• Double-click chart > “Правка Data” for embedded charts
• Linked charts pull data from Excel; embedded charts contain data in Word
• If Excel Файл moves, update link location (Файл > Info > Правка Links to Files)
• Breaking a link converts it to embedded; you lose automatic updates
• Test links work before sharing документ 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