Create a new ODC file with a unique data source

Step

Action

Details

1

Launch Excel 2010

2

On the Data tab, in the Get External Data group, click From Other Sources, and then click From Data Connection Wizard.

3

Select Microsoft SQL Server, and then click Next.

4

Enter the name of the server (by default, it is the network name of the computer) and a user account that has a valid login and database permissions.

Server Name: MPNTPRJ10G

Select Use Windows Authentication radio button

Click Next.

5

Select a database ProjectServer_PS_Reporting, and then highlight the table you want to connect to (MPN_DepartmentKPIValues in our example)

You could also choose to write a sql statement that draws data from multiple tables or views and use that instead. 

Click Next.

6

Enter a name for the file, and then click Finish.

Use the given name

<img style="background-image: none; border-right-width: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px; padding-top: 0px" title="clip_image012" border="0" alt="clip_image012" src="https://integent.com/Portals/0/SunBlogNuke/1/Windows-Live-Writer/041c6de91daa_948B/clip_image012_thumb.jpg" width="244" hei