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

exporting excel

Forum home » Delegate support and help forum » Microsoft Project Training and help » Exporting to Excel

Exporting to Excel

ResolvedVersion 2003

Cheryl has attended:
PowerPoint Introduction course
Visio Introduction course
Project Intro Intermediate course

Exporting to Excel

Is there any way to export a report to excel?
I need to produce a list of tasks for all resources & have found a custom report entitled "To Do List" which suites my purpose. However I would like to export this information to excel. Can anyone help please?

RE: Exporting to Excel

Hi Cheryl

Thank you for your question. There is no way to convert a report to excel. An alternative would be to filter the chart to show the tasks you are interested in (Project > Filtered for > Using Resource) then click the select all square (above the row numbers and to the left of the column names). From the edit menu choose Copy Cell and switch to Excel. Paste the contents of the clipboard into Excel and you will have just the filtered tasks for your chosen resource.

I hope this helps.

Kind regards, Andrew

MS Project tip:

Entering Days

To type in a day of the week, or its three letter abbreviation, in a Date field type "Monday" or "Mon", and Project will show the date for the next Monday after the current date.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.