Home > e-infrastructure, Learning-logs, service-is-project-managing > First steps with MS-Calendar Analytics

First steps with MS-Calendar Analytics

  1. After installing Calendar analytics (and, if you do not already have it, PowerPivot), open the Calendaranalytics spreadsheet from your desktop and click on “Refresh Calendar”.
  2. “Enter your full email address.  Users with more than 1 email address may need to try each of them.”
  3. clip_image001
  4. clip_image002
  5. “Enter a start date and end date for the timeframes for the Dashboard to reflect”/
  6. “The interface will prompt you for the user’s aliases to add.  You can add multiple.”
  7. clip_image003
  8. “Type in users’ aliases of whom you have permission (i.e. “Full details”) to access their Outlook calendar and click Add”
  9. clip_image004
  10.  clip_image005
  11. Do not use the fully qualified email address for the alias, or else:
  12. clip_image006
  13. You cannot comma delimit  (so AutoIt to the rescue).
  14. clip_image007
  15. You can continue after such a non-fatal error:
  16. clip_image001
  17. clip_image002
  18. Is your “Update all” greyed out ? Restart Excel.
  19. clip_image003
  20. Accept the offer to upconvert:
  21. clip_image004
  22. clip_image005
  23. clip_image003
  24. Update all becoame available after restart of excel, even with download exceptions – maybe the unsaved update of the spreadsheet form powerpivot 1 was the root cause ?
  25. Not that here upconversion to the new powerpivot version does not “take”:
  26. clip_image006
  27. If after a restart of excel your powerpivot tab on the ribbon  does not show, reenable the powerpivot addin.
  28. How to reenable: excel file/ options / select dropwdown: addins, button:go, check the Checkbox  in front of powerpivot:
  29. clip_image007
  30. What if even after a restart of excel, this does not “take”?  See whether in the registry the key   CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Resiliency\DisabledItems contains the path to your powerpivot add-in,like here:
  31. clip_image008
  32. Delete the key and restart excel, your powerpivot ribbon tab =should be back. Hope this will last?
  33. clip_image009
  34. Now updating does something:
  35. clip_image010
  36. This opens the powerpivot window with the meeting data collected fro mms-exchange:
  37. clip_image011
  38. Which can be interactively: visualized in the calendaranalytics sheet
  39. clip_image012
  40. More results here.
  1. Niah
    2014/05/02 at 05:13

    Hi, unfortunately I am not able to install Calendar Analytics with Excel 2013. Is it asking for some share tool which is not available in Excel 2013. Howevery there must be a solution to run this with Excel 2013 right?! I really want to try it out and will appreciate your help. Thanks a lot, Niah

    • 2014/05/02 at 13:20

      Hi Niah, I think with the arrival of Excel 2013 (I have still been using Excel 2010 with PowerPivot at work) there has been a licensing change for PowerPivot – which is what Calendaranalytics uses internally, you will see the PowerPivot on the ribbon, and a PowerPivot table open in the background when you open the Calendaranalytics spreadsheet. I also think I read, after many complaints, Microsoft loosened the licensing restrictions for PowerPivot in the very recent past – I do not recall the details, but I suggest you research down that path. Good luck! Thomas

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: