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 » Exporting to Excel
Exporting to Excel
Resolved · High Priority · Version 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
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:Set default task type - Project 2010a. In Project, click on the File tab |