Create a data connection from MS Project Server to Excel 2007

Question

Hi I have a Project plan which sits on MS Project Server. What would be the easiest way for me to create a data connection which isn't just a one time refresh from Project to Excel with the use of VBA?

I could obviously take an extract manually each time from MS Project to Excel but wondering if there is anything I can use to automate this via a Data Connection in Excel?

Answer 1

You can create an Excel data connection which uses an identity from the securestore (as described here) and then query the project server database (some sample queries here)