project 2007 server training - exporting project data into

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

MS Project tip:

Use Autofill in MS Project

a. Complete 1st entry
b. Select cell with entry to be copied
c. Click & drag autofill handle over the lines to also contain the same information. (the autofill handle is the little black square in the bottom right hand corner of the heavy lack outline on the selected cell)

View all MS Project hints and tips


Server loaded in 0.08 secs.