![microsoft excel data analysis add in microsoft excel data analysis add in](http://home.ubalt.edu/ntsbarsh/excel/Image10.gif)
![microsoft excel data analysis add in microsoft excel data analysis add in](https://miro.medium.com/max/1200/1*YMAKwQy8Chuo9yOnNdHGtg.jpeg)
The User and Password properties, under the Authentication section, must be set to valid Microsoft Project userĬredentials. If you have not already done so, create a new Microsoft Project connection by clicking From Microsoft Project on the ribbon. In this example, you will use the Projects table however, the same process will work for any table thatĬan be retrieved by the CData Excel Add-In. This technique is useful if you want to work on Microsoft Project data in Excel and update changes, or if you have a whole spreadsheet you want to import into Microsoft Project.
MICROSOFT EXCEL DATA ANALYSIS ADD IN HOW TO
This article explains how to transfer data from Excel to Microsoft Project. The CData Excel Add-In for Microsoft Project enables you to edit and save Microsoft Project data directly from Excel.