Chapter 12

Linking, Automating, and Sharing Spreadsheets


Using Office and Excel Add-ins to automate and enhance Excel 2016

Adding hyperlinks to other workbooks, worksheets, Office documents, web pages, or email

Creating and using macros to automate common spreadsheet tasks

Sharing your worksheets on the web

Editing your worksheets in a web browser with Excel Online

At your first reading of the chapter title, you might have the impression that this is just a catch-all, potpourri chapter, containing the last bits of program information that don’t fit anywhere else in the book. Actually, this is not the case because this chapter has a very definite theme, and that theme is how you go about extending the power of Excel 2016.

It just so happens that apps for Office, Excel add-ins, hyperlinks, and macros are four major ways to make Excel more vigorous and versatile: add-ins through the extra features they give Excel 2016; hyperlinks through links to other worksheets and Office documents; and web pages and macros through complex automated command sequences that you can play back whenever needed. And sharing your worksheets by attaching them to email messages or publishing them to the web as well as being able to edit them anywhere in the world using the Excel Online web application are all part of the new collaboration features that enable you to both communicate and collaborate more quickly and effectively.

Using Office Add-ins

Office Add-ins are small programs ...

Get Excel 2016 For Dummies now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.