SharePoint 2010 Web Analytics customize report date shows 1/0/1900

Issue

The dates in the Excel Sheet are 1/0/1900 when creating a customize report for example the report of the Number of Daily Unique Visitors.

image

Solution

The solution is quite simple because you only need to verify a few things and maybe start a few services.

– Verify that the following service applications have been started/installed

  • Excel Services Application
  • State Service
  • Usage and health data collection
  • Web Analytics Service Application

– Verify that the trusted file location in Excel Services Application has ‘Allow user-Defined functions’ enabled.

– Verify that the following services in SharePoint have been started

  • Claims to Windows Token Service
  • Excel Calculation Services
  • Web Analytics Web Service
  • Web Analytics Data Processing Service

You should be able to see the correct data after checking the above settings

image

Leave a Reply

Your email address will not be published. Required fields are marked *