10/30/2023 0 Comments Excel 2013![]() ![]() On the Save Data Connection File and Finish step, click Finish. On the Data Connection Wizard dialog box, select the check box next to Projects, and then click Next. Log in using your Microsoft 365 credentials. Location of the data feed, in the Link or File box, type the website address (URL) for your Project Web App instance, followed by: /_api/ProjectData/.įor example, if you access Project Web App at, then you would enter in the Link or File box. On the Data tab, in the Get External Data group, choose From Other Sources > From OData Data Feed. In Excel 2013, choose File > New > Blank workbook. The first step is to create a connection in Excel 2013 that points to your Project Online data. Step 1: Create a connection to your Project Online data in Excel 2013 Step 4: Open your report in Project_Online Step 3: Save your report to Project_Online Step 2: Choose data to include in your report Step 1: Create a connection to your Project_Online data in Excel 2013 The following steps are covered in this article: You can do much more than this with Excel 2013 and an OData connection to your Project Online data, but since you’re just getting started, we’ve kept this example simple and straightforward. This article walks you through creating a data connection in Excel 2013 to your Project Online data to show a list of projects in a PivotTable report. This is a one-time setup step that will allow your reports to refresh properly in Excel for the web. Important: Before following the steps in this article, it is important that you grant reporting access in Project Online first. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |