Home
> e-infrastructure, Learning-logs, service-is-project-managing > First steps with MS-Calendar Analytics
First steps with MS-Calendar Analytics
- 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”.
- “Enter your full email address. Users with more than 1 email address may need to try each of them.”
- “Enter a start date and end date for the timeframes for the Dashboard to reflect”/
- “The interface will prompt you for the user’s aliases to add. You can add multiple.”
- “Type in users’ aliases of whom you have permission (i.e. “Full details”) to access their Outlook calendar and click Add”
-
- Do not use the fully qualified email address for the alias, or else:
- You cannot comma delimit (so AutoIt to the rescue).
- You can continue after such a non-fatal error:
- Is your “Update all” greyed out ? Restart Excel.
- Accept the offer to upconvert:
- 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 ?
- Not that here upconversion to the new powerpivot version does not “take”:
- If after a restart of excel your powerpivot tab on the ribbon does not show, reenable the powerpivot addin.
- How to reenable: excel file/ options / select dropwdown: addins, button:go, check the Checkbox in front of powerpivot:
- 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:
- Delete the key and restart excel, your powerpivot ribbon tab =should be back. Hope this will last?
- Now updating does something:
- This opens the powerpivot window with the meeting data collected fro mms-exchange:
- Which can be interactively: visualized in the calendaranalytics sheet
- More results here.
Leave a Reply
Questions? Read the About. Or just ask me a quick
FAQs for LRC student staff or for students or for teachers. To search our FAQs, in the browser addressbar, add after "https://plagwitz.wordpress.com/feed/?tag=faqs+/" "+TAG1" (from tag cloud below) OR "https://plagwitz.wordpress.com/feed/tag=faqs
&category_name=" "CAT1" (from category hierarchy below). OR search both categories and tags, and multiple TAGs/CATs (connect with "," for OR-search, with "+" for AND-search), like so: https://plagwitz.wordpress.com/feed/?tag=TAG1+TAG2+...TAGn&category_name=CAT1
+CAT2+...CATn"
Other ways to find help
If you cannot find it here, look there: 5,500 Language-Learning Links and Programs for learning or teaching 150 languages
Shortcuts:Our Lists, Our Maps, LRC Staff Moodle Site,LRC Project Moodle Site, 49erexpress, UNCC Moodle, Student Recordings: s:claslcslrcsanakostudent
Learning usage samples: Sanako oral exam, Kaltura webcam presentation, Dictation with speech recognition, Sanako written exam, Chinese and Japanese interactive stroke-order practice
Test the Sanako Installer, Webbrowser Popup Konfigurator for XP, or Windows7, faster LRC TeacherPC Log-in Let MS facilitate diacritics writing by installing for you US-International keyboard layout
This is my personal blog (Google+). The views expressed on these pages are mine alone and not those of my employer. The information in this weblog is provided “AS IS” with no warranties, and confers no rights.
Thomas' Work Space 
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
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