When you edit a Word document, you need to use the data from the Excel worksheet, but when one of the data in Word and Excel changes, we have to look for a corresponding part to modify, and if the amount of data involved is large, the strength of the work is greatly increased. In fact, Word and Excel provide a way to keep both data synchronized and simple.
STEP1: Copying paragraphs
Open the Word document and the Excel worksheet that you want to reference the Word data, and then return to your car in Word, displaying two paragraph marks. Select the two paragraph marks, and then copy.
STEP2: Paste Link
Switch to the Excel editing window, right-click the data bar, select Paste, paste the link in the pop-up window, select the Microsoft Office Word Document object, and then click OK to exit.
STEP3: Synchronous input
Return to the Word document and enter the contents, including pictures and tables. After a few seconds, the changed Word data is displayed in Excel so that synchronization is achieved. If you want synchronization to be faster, then click the Save button on the Word toolbar after you enter the content.
What you need is that when you enter content in Word, you cannot enter it before the last paragraph mark, otherwise it will not be synchronized properly, so it must be entered on the last segment of the cast or entered again before it is valid.