Synchronize data in Word and Excel tables to update

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.