You can create an Excel report for a project with a data connection to the
PIM database. This allows you to update the report at any time with current data. All contract items for a project are included in the report, except for draft items, and items awaiting approval.
To create an Excel report with a data connection:
-
Navigate to the project.
You can search for projects using the
Search Projects link in the
Activity Zone. Projects that you are linked to also appear on the History tab on your contact record, and in the Projects dashpart in the
Personal Zone.
-
Click the Contract Management tab.
If the Contract Management tab is not visible on the header band, click
more to display additional menu items.
-
Click
Excel Report.
-
Select to save the spreadsheet to your PC, and then choose a folder to save the report in.
-
Open the spreadsheet in Excel.
-
If prompted, click
Enable Editing.
-
If prompted, click
Enable Content.
-
On Sheet1, click
.
-
If prompted, enter your
PIM username and password.
The spreadsheet populates with live data from the
PIM database. In future, when you want to update the spreadsheet with the latest data, click
on the spreadsheet.