How to link update automatically in Excel 2013 without any notification when file open

Often when we link one workbook with another workbook and when we close and re-open the linked workbook a message appear on screen (see below snapshot)

 After this massage when we click the Continue the link will be update. If we cancel it the links are not updated.
Let’s start to how the links update automatically without any massage or clicking continues or something else.

Click the Edit link

The Edit Links windows popup massage appear in screen

Click the Startup Prompt…

Click the don’t display the alert and update link

Or if you do not need to update automatic links and don’t display the alert.
Click the Don't display the alert and don't update automatic links

Or if you want to view alert all the times when you open the worksheet then click the
Let’s user choose to display the alert or not (default)

No comments:

Post a Comment

Recommended for You


Related Posts Plugin for WordPress, Blogger...