project 2007 server training - Exporting Project data into Excel

Resolved · Low Priority · Version Standard

Wed 24 Oct 2007, 10:46 Delegate Anja said...

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

Tue 6 Nov 2007, 12:13 Trainer Andrew said...

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 courses

	98.7 % recommend us
	More live stats...

Training information:

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