Post

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. 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 […]

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

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archive