Faisal Masood has posted an article on How to use Excel to access data from project server 2003 database. We are using Excel extensively for project server reports and pivot charts. Our executive love reports in Excel instead of PWA – Portal Folio Analyzer. You can check this article from here