Ever wondered how to produce nice looking reports based on Project Server OLAP data (cubes) using Excel 2007 and Excel Services without using the Office Web Component (OWC).
The document below explains the steps to follow to integrate Project Server 2007 with Excel Services (Microsoft Office SharePoint Server). This document assumes that you already have installed MOSS and Project Server 2007 on the same farm.
Data Analysis Report Using Office Web Component
Data Analysing Report Using Excel Web Access
To learn about Excel Services security settings please check the following: