This Wiki article documents some known issues with version 1.0 of Calendar Analytics.

There is a new Wiki article for version 2.0 Calendar Analytics.  The new Wiki article outlines new features, bug fixes, and Office 15 compatibility in version 2.0 found here: http://social.technet.microsoft.com/wiki/contents/articles/13338.calendar-analytics-for-office-15.aspx

You can download the latest version of Calendar Analytics from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4c13a670-3356-4d4a-a24b-d33143004eb6

Table of Contents


"Exceptions downloading..." message box


ISSUE:
After clicking the Refresh Calendar button and walking through dialogs, a message box may appear after downloading calendar items:
"Exceptions downloading 3 of 427 meetings for: someone@extendedresults.com"

CAUSE:
The specified number of calendar items did not download correctly. Some unknown characteristic of the calendar item has caused Calendar Analytics to not download the item. One possible cause is that the calendar item does not have an Organizer specified, which is required by Calendar Analytics.

SOLUTION:
Click OK and continue by going to the PowerPivot tab and clicking Update All, and then go to the Data tab and click Refresh All. The specified number of meetings in the message box will not be included in the dashboard.


"The email address ________ is not the primary SMTP address." message box

ISSUE:
You entered in an alias in the Alias List dialog box, and when you click Next and the following error message displays

"The email address JohnD@somewhere.com is not the primary SMTP address."

CAUSE:
It is possible that the person that you entered has multiple email addresses.

SOLUTION:
Find out if they have an alternate email address, for example "John.Doe" rather than "JohnD".

User Feedback: I have both jane.doe@microsoft.com and janed as alias entered. No dice. Still returns either the message that my email address is "not the primary SMTP address" ...restarting computer didn't help.


Calendar Analytics fails to install after installation reboot

ISSUE:
You ran the CalendarAnalytics.exe setup program and prerequisites such as VSTO Runtime and .NET Framework has prompted you to reboot. After the reboot, an error message appears stating that Windows Installer cannot find the .MSI.

CAUSE:
In some instances, such as installing from a Shared drive or USB Drive, Windows Installer does not copy the .MSI to the Windows temp folder.

SOLUTION:
Re-run the CalendarAnalytics.exe setup program after the reboot.


"Days Out of Office" field on "What" worksheet is not accurate


ISSUE:
The "Days Out of Office" field on "What" worksheet does not always give the expected result.

CAUSE:
This field was misnamed. The appropriate field description is "Out of Office Meetings".

SOLUTION:
Select the cell with Days Out of Office and type "Out of Office Meetings".


ALERT: Incomplete Calendar Download


ISSUE:
You clicked the Refresh Calendar button on the What tab of the Calendar Analytics spreadsheet. You entered your email address as it is for the Exchange Server. You entered the the current month for your Start and End dates and did not enter any other alias. You then receive a box that the calendar download was incomplete and the following dates were skipped: all query dates are listed.

CAUSE:
There may be an issue with your Exchange Server 2010 and Exchange Web Services configuration.

SOLUTION:
Ensure that Microsoft Exchange Server 2010 is installed and configured correctly with Exchange Web Services. Please contact Exchange Server or Exchange Web Services support for assistance.



ERROR: Communication - Autodiscover service could not be contacted ...


ISSUE:
You entered your email address, checked the Office 365 box, and provided your password. After walking through the steps you received the error message "Communication - Autodiscover service could not be contacted..."

CAUSE:
There might be an issue with your Exchange Server 2010 and Exchange Web Services configuration.

SOLUTION:
Ensure that Microsoft Exchange Server 2010 is installed and configured correctly with Exchange Web Services. Please contact Exchange Server or Exchange Web Services support for assistance. You can also try installing Calendar Analytics on a different computer that is not on the same domain as your Exchange Server. For example, if you are @microsoft.com and your email address is an Office 365 account, try installing on a machine that is not on the REDMOND domain.



"Cannot implicitly convert type 'double' to 'string'." messagebox


ISSUE:
After clicking the Refresh Calendar button and walking through dialogs, a message box may appear while downloading calendar items stating: "Cannot implicility convert type 'double' to 'string'".

CAUSE: 
Excel is treating one of your "Categories" as a numeric data type rather than a string.

SOLUTION: 
Format all of the cells in the "Categories" worksheet as "Text" and try again.