98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » project 2007 server training - Exporting Project data into Excel
project 2007 server training - Exporting Project data into Excel
Resolved · Low Priority · Version Standard
Anja has attended:
Project Intro Intermediate course
Exporting Project data into Excel
I've created a project plan in MS Project and need to export it to Excel.
I've gone through most of the steps but get stuck on the last bit where I have to identify what information I want to add/delete to the export.
Could you please advise of steps? I've looked this up in the MS Project guide but couldn't find any information about it.
Thank you.
Anja
RE: Exporting Project data into Excel
Hi Anja
Thanks for your question - to help streamline the selection of fields you might want to try this approach. When you get to the task mapping part of the process take a look at the row of buttons. On the far right side you will find one called "base on table". Give it a click and you will find a list of the tables in Project. You might find it easier to base your export on an exisiting table then add any additional fields you require.
Hope this helps,
Do let us know if you have any questions,
Kind regards,
Andrew
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Use Autofill in MS Projecta. Complete 1st entry |