Synchronize word with Excel

First round

The requirements are as follows:

1. Tables in Excel can be displayed in word.

2. After table L in exce is changed, the content in the word table must be updated.

The supported platform is office 2011 on Mac.

Implementation:

Select the expected table area in Excel and copy it.

In word, paste special => paste link => HTML format.

Modify the table content in Excel, and the word will be updated immediately (theoretically ).

But sometimes it is not synchronously updated. In this case, select Edit => links... => link => Update now in the menu.

Is it easy? Office is actually very powerful.

Second round

Requirement: After Excel and Word are sent to others, the Excel and Word tables should be synchronized.

Implementation:

Because word stores links in absolute paths, you need to manually update the Excel file location in word after receiving Word and Excel from others.

In the menu, select Edit => links... => select link => change Source

Round 3

Requirement: The style adjustment of the table in Excel should not damage the layout of the table in word.

Implementation:

The paste link method is used to paste not only the content but also the style. When the style is over, the style is still invisible. As long as the cell size is adjusted in Excel, the word synchronization style will be ruined.

This problem cannot be solved through the user interface. It can only be solved through VBA. Refer:Http://mac2.microsoft.com/vb/1033/word/html/womthaddfieldsobj.htm.

Set preserveformatting to true to maintain the style on the word side.

Fourth round

The requirements are as follows:

1. Charts in Excel can be displayed in word.

2. After Chart L in exce is changed, the content in the word chart must be updated.

Implementation:

Select a chart in Excel and copy it. In word. Done.

After changing the number in Excel, the word will be updated. However, if the style of the chart is changed in Excel, the word won't.

The reason is that word generates an independent new chart based on the Excel chart, but the data source is the same cell in the same Excel file.

If no automatic update is available, use Edit => links .. => select link => Update now

Fifth Round

Requirement: After Excel and Word are sent to others, the Excel and Word charts should be synchronized.

Implementation:

Try one:

Theoretically, we can use the previous method to solve the problems caused by absolute path changes by changing source. However, this method does not work for charts. At least office 2011 in MAC cannot work, but it has not been tested in windows. The same is true if you use VBA to change source.

Test 2:

In addition to normal paste, there is also paste link. If paste link is used, you can use change source. However, the problem with this method is that the chart is an image on the word side, and the resolution is very low, which affects the final output quality.

Try 3:

Paste it again. Use alt text to record the original source and paste it again with VBA. Of course, the brute force method is feasible.

Test 4:

Can I leave the absolute path unchanged? Use hdiutil create test. DMG-megabytes 100-ov-type sparsebundle-Fs HFS + J-volname test generate a DMG file, and then put the Excel and Word documents in the mounted drive, in this way, the path is the same for all people.