I have updated the Calendar Template to include Categories and better calculation of recurring meetings.
Note: This is no longer the official template under File–>New, but an improved one. Microsoft may consider using it in the future version, but I am no longer there to push it through 🙂
Help me improve it by sharing your feedbacks.
Happy new year!
Gil
Does this excel tool work with Google Calendar?
No. You may be able to connect to Google Calendar using the Web connector, and Google Web Rest APIs. But I never tried it.
This tool does not work anymore. Please address the Q&A thread on the hosted page (https://gallery.technet.microsoft.com/Calendar-Insights-Template-5f8d80d3)
Thank you for sharing. You can connect to Microsoft Support if the issue is resulted in the Exchange connector itself. Can you please elaborate here which error you have?
Different person here than the Anon above. I’m getting error 1004 saying “Query – Meetings” doesn’t exist or I don’t have access. I’m running on-prem Exchange Server 2013 and using Office 2016.
I am afraid you will need Microsoft official support here, or try to contact your IT to troubleshoot this error with you.
I did reach out to them and T1 support didn’t have a clue, pointed me to “Pro Support” for $499… I’ll just have to reach out to some old coworkers at MS and see if they can get this to the Excel online content team. Can you just confirm this still works for you locally, though? Would be great to know if it’s broken for everyone or just a few; I’ve seen a number of folks reporting this issue on various forums.