How Excel documents Cancel Update link hints

Large in the use of office2010 made two Excel document set up links between the table will be prompted to update the link, then office2010 Excel document How to cancel the update link hint? In fact, the method is very simple, as long as the data found in the edit link to cancel the hint on the Oh, Let's take a look at the following with small knitting.

office2010 Excel document Cancel Update link hint method:

Create a new two office2010 Excel document and set the links between the tables as shown in the figure:

After saving, when you reopen the document, you are prompted to update the link, as shown in the figure:

We click on the "Data" button at the top of the document to open the Data menu, as shown in the picture:

Click the Edit Link button on the Data menu to open the Edit Link dialog box, as shown in the following picture:

#office2010 Excel document How to cancel the update link hint 2#_

In the Edit Link dialog box, click the "Start Prompt" button to open the launch prompt, as shown in the picture:

At the start prompt interface, choose not to display a warning, then click the "OK" button and save, the next time you open the document will not be prompted to update the link, as shown in the figure: