Connect to Project data with Microsoft Office Excel 2007

  • Article

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

Before you perform this procedure, confirm that:

  • You have read the article named View OLAP Cube data.

  • You have Read access to the Project Server Reporting database in SQL Server.

  • You have Microsoft Office Excel 2007 installed on your computer.

To connect to Project cube data with Excel 2007

Use this procedure to connect to the Project data in the Office Project Server 2007 Reporting database with Excel 2007.

Connect to Project cube data with Excel 2007

  1. Open Excel 2007.

  2. On the Data tab, click From Other Sources, and then click From Analysis Services.

  3. Specify the Analysis Services database server name, and then click Next.

  4. In the Data Connection Wizard, select the cube database name.

  5. Verify that Connect to the specific table is selected. From the table-name list, select the cube name you want to connect to, and then click Next. Click Finished.

  6. On the Import Data page, click Finish.

If you have Microsoft Office SharePoint Server 2007, the Excel Service allows you take Project cube data in your Excel workbook format and make it available to your users through a Web browser (Excel Web Access).

For detailed information about configuring Excel Services to view OLAP cube data, see Building an OLAP PivotTable Report with Excel Services (https://go.microsoft.com/fwlink/?LinkId=91189\&clcid=0x409)

For more information about Excel Services, see White paper: Excel Services step-by-step guides.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Project Server 2007.