Disable update links message with Edit Links feature Disable update links message with Excel Options Edit Links, see screenshot: 2.In the Edit Links dialog box, click Startup Prompt button at the bottom, see screenshot: 3.Then click OK to close this dialog, when you open this workbook next time, the links are automatically updated, and additionally, no message appears.
You can also remove any worksheets you and your colleagues won’t need by right-clicking the tab of an unneeded worksheet and, on the shortcut menu that appears, clicking Delete.
TIP You can also save your Excel 2016 workbook either as an Excel 97–2003 template (.xlt) or as a macro-enabled Excel 2016 workbook template (.xltm).
For information about using macros in Excel 2016 workbooks, see Chapter 12, “Automate repetitive tasks by using macros.” When you create a new workbook by using the tools found in the Backstage view, the New page displays the blank workbook template, built-in templates, a search box you can use to locate helpful templates on Office.com, and a set of sample search terms.
Especially if a stream of Excel documents that require processing threatens to overflood you.
Let’s focus on just one aspect of such work – working with links in Excel workbooks. The add-ins brought to your attention in this review are purposed for solving the complex task of searching for links, checking their validity and giving you a helping hand in case something goes wrong.