microsoft project

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

Forum home » Delegate support and help forum » Microsoft Project Training and help » Microsoft Project

Microsoft Project

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


 

MS Project tip:

Email a Task

When 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.

1.In a task sheet, select the task or tasks which you want to send a project note.

2.On the File menu, point to Send To, and then select Mail Recipient (as Schedule Note).

3.Under Address message to, select the recipients of your note.

View all MS Project hints and tips


Server loaded in 0.08 secs.