Configuring Excel Services with Project Server

I wanted to call your attention to this new TechNet article on how to set up Excel Services with Project 2007.  https://technet.microsoft.com/en-us/library/cc770224.aspx

This set up procedure was developed by my Business Intelligence team with the Excel Services team.  One of the items which will make it easier to implement is that this procedure does not require Kerberos for your security setup.  It also enables report creation using a tool that is very familiar to report creators.

Enjoy this and more original Project posts at our blog:  https://blogs.msdn.com/project

In planning your Excel based reporting solution, you may also be interested in this “light” reading list below.

• Excel Services Data Connection Demo https://office.microsoft.com/en-us/sharepointserver/HA102078901033.aspx
• Planning External Data Sources https://technet.microsoft.com/en-us/library/cc262899.aspx
• Plan Data Connections Management  https://technet.microsoft.com/en-us/library/cc263151.aspx
• Plan Excel Services Security  https://technet.microsoft.com/en-us/library/cc263086.aspx

Once you’ve set up your environment, these sample reports can easily be implemented.  You will need to change the data connection in each report to use the correct Single Sign On(SSO) id that you’ve configured.  https://blogs.msdn.com/chrisfie/archive/2008/04/13/new-excel-services-sample-reports-for-project-server.aspx

Technorati Tags: Project Server 2007,Reporting,Excel Services