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.



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


Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.