excel vba update links

It is quite common to link data from other workbooks in an Excel workbook. But every time you open a workbook like this, Excel automatically pops up a "Do you want to update the data Link" prompt dialog box, which is annoying. Let's just let it "disappear" and update the data link automatically. Click the edit → link

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 can

It is quite common to link data from other workbooks in an Excel workbook. But every time you open a workbook like this, Excel automatically pops up a "Do you want to update the data Link" prompt dialog box, which is annoying. Let's just let it "disappear" and update the data link automatically. Click the edit → link