How to save Calendar Insights workbook with your data in Excel 2016

One visible alter that you lot volition uncovering inward Excel 2016 inward comparing to its before versions is the add-on of a novel template called Calendar Insights. The template displays a detailed tape of how much fourth dimension you lot pass inward meetings, whom you lot come across amongst the most too which business office of the twenty-four hours you lot uncovering most appropriate to come across the people. You tin sack uncovering your calendar inward the shape of a dashboard, too start out interacting from there. So, inward this post let’s catch how to Open too the Calendar Insights workbook amongst your information inward Excel 2016.

Save Calendar Insights inward Excel 2016

Open Excel too search for the Calendar Insights template.

Now, to access your calendar using the template, you lot yell for an active concern human relationship on an Exchange Server, or on Exchange Online every bit business office of your Office 365 subscription.

If your concern human relationship is active, select New inward Excel 2016 too navigate the cursor to ‘Calendar Insights’.

If you lot bring whatever difficulty finding the template, role the search box of the application too type calendar insights. The Calendar Insights template should look on completion of the action.

Open the template too you lot should catch the start workbook tab, titled Start. Select the Let’s Get Started push clitoris to begin.

Towards the bottom, you lot volition catch the ‘Import Your Calendar tab is selected’, providing steps almost how to connect to the Exchange Server too import your calendar.

Hit the Sign inward button! When you lot produce this, Excel app volition display a dialog that requests user to movement into an electronic mail address too password, too then the app tin sack connect to your Exchange Server too charge your calendar information into the workbook.

Once complete, the Meeting Insights worksheet appears too shows a populated dashboard that features a collection of detailed analytics based on your calendar.

To relieve the Calendar Insights workbook amongst your information every bit a macro-enabled workbook, produce the following:

Select File, scroll downwards to locate ‘Save As’ option. Hit the button!

Next, select a goal too select Excel Macro-Enabled Workbook inward the Save every bit type drop-down menu. Saving the workbook every bit a macro-enabled workbook ensures that all charts are updated automatically, everytime you lot select the Refresh Insights push clitoris on the Meeting Insights worksheet.

Finally, if you lot require whatever kind of information from your calendar, opened upwards the workbook too select the Refresh Insights push clitoris at the bottom of the Meeting Insights worksheet.

TIP: Download this tool to chop-chop uncovering & laid Windows errors automatically