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 » Microsoft Project
Microsoft Project
Resolved · Low Priority · Version 2000
Brian has attended:
Project Intro Intermediate course
Microsoft Project
Is there an easy way to set up excell spreadheet reports so that actual dates can automatically be imported into Project directly, avoiding any need for manual changes within project once the programme is baselined?
RE: Microsoft Project
Hello Brian,
Hope you enjoyed your Microsoft Project course with Best STL.
Thank you for your question regarding working with Excel and Project.
If you are importing tasks from an Excel sheet you don't need to use dates since Project will automatically insert the current date which you can then change. After inserting the durations you would then link the tasks together and all dates would then be calculated for you. There is no need to use dates in an Excel sheet for importing. You can however, include a Duration column in Excel, which when imported will make the calculations of dates much quicker.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Thu 16 Sep 2010: Automatically marked as resolved.
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:Email a TaskWhen you need to communicate important information to your project staff use Microsoft Project 2003 to send them a note using outlook or an e-mail system. |