修复: Charts Not Updating in Word

The 问题

Your Word 文档 contains a 图表 created from Excel data, but when you 更新 the Excel 文件, the 图表 in Word doesn’t change. The 图表 shows outdated numbers from months ago. Manually changing the 图表 in Word doesn’t sync back to Excel. The link between Excel and Word is broken. You want the 图表 to always reflect current Excel data.

Quick 修复

更新 linked 图表 immediately:

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

If you don’t see “更新 Link” option, it’s an embedded 图表 (data is in Word, not linked to Excel). Proceed to 步骤-by-步骤 解决方案.

步骤-by-步骤 解决方案

步骤 1: Understand Linked vs. Embedded Charts

Different fixes apply to each type.

1. Right-click the 图表 in your Word 文档
2. If you see “更新 Link,” it’s linked to an external Excel 文件
3. If you see “Edit Data” or “Edit 图表,” it’s embedded in Word

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

步骤 2: 修复 Linked Charts (Links to Excel)

If your 图表 is linked and not updating:

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

The 图表 should now display current Excel data.

步骤 3: Manually Refresh the Link

Force Word to 检查 for updated data.

1. Right-click the 图表
2. Select 更新 Link
3. Alternatively, go to 文件 > Info and look for Edit Links to Files
4. Select your linked 图表 data
5. Click 更新 Now
6. 图表 refreshes

Do this whenever you’ve updated the source Excel 文件.

步骤 4: Edit Embedded 图表 Data Directly

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

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

步骤 5: Change Linked to Embedded (or Vice Versa)

If you want to switch between linked and embedded:

To embed a linked 图表:

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

To link an embedded 图表:

1. Delete the embedded 图表
2. Go to Insert > 图表 or Insert > Object > Create from 文件
3. Browse to your Excel 文件
4. 检查 “Link to 文件” (don’t 检查 “Display as icon” if you want to see data)
5. Click OK
6. 图表 now linked to Excel

步骤 6: 检查 if Excel 文件 Still Exists

Linked charts break if Excel 文件 is moved or deleted.

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

步骤 7: 更新 Excel 文件 and Manually Refresh

1. 打开 the Excel 文件 separately
2. 更新 the data
3. 保存 the Excel 文件
4. Return to Word
5. Right-click 图表
6. Select 更新 Link
7. 图表 now reflects the new Excel data

步骤 8: Delete and Reinsert 图表 as Linked

If 图表 won’t 更新 despite being linked:

1. Right-click the 图表 and delete it
2. Go to Insert > 图表
3. Select From 文件 or Object
4. Browse to your Excel 文件
5. Select the 文件 and click 打开
6. A dialog appears asking whether to link or embed
7. 检查 “Link to 文件” for linked 图表
8. Uncheck “Display as icon” if you want to see data
9. Click OK
10. 图表 reinserts and should 更新 properly

步骤 9: 验证 Excel Range is Correct

If data is in Excel but 图表 uses wrong range:

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

步骤 10: 启用 Automatic Link Updates

Some Word versions allow auto-更新 of links.

1. Go to 文件 > Info > Edit Links to Files
2. In the Links dialog, select your 图表 link
3. Look for an “Automatic” checkbox or “更新 Method” option
4. If present, ensure “Automatic” is checked
5. Click OK
6. Now the 图表 updates automatically when you 打开 the Word 文档

Why This Happens

1. Embedded instead of linked — 图表 is copy of data, not link to source
2. Excel 文件 moved — Link breaks if source 文件 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 打开 — Some charts only 更新 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

如何 Prevent It

1. Relink after moving files — If you move Excel 文件, 更新 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 文档 — 验证 charts 更新 before sending
5. Keep Excel 文件 in consistent location — Don’t move source files often
6. 更新 links before sharing — Right-click > 更新 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 图表 is linked to

Still Not Working? Alternative Solutions

1. Recreate 图表 in Excel — Delete Word 图表, create new 图表 in Excel, copy/paste to Word
2. Convert to 图像 — Copy 图表, 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 更新 — If linking doesn’t work, break link and manually 更新 图表 data
7. Use Word’s built-in 图表 — Insert > 图表 > use Word’s native 图表 工具 instead of Excel
8. Contact Microsoft 支持 — For persistent linking issues, get technical 支持

Key Takeaways

• Right-click 图表 > “更新 Link” for linked charts
• Double-click 图表 > “Edit Data” for embedded charts
• Linked charts pull data from Excel; embedded charts contain data in Word
• If Excel 文件 moves, 更新 link location (文件 > Info > Edit 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