viewing tasks

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

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

Viewing tasks

resolvedResolved · Medium Priority · Version 2003

Josh has attended:
Project Intro Intermediate course

Viewing tasks

In excel I have created two task views - one based on the flow of tasks over time and another where the tasks are broken into key business areas. This is very useful when managing the work of different teams across a project - what is the best way of doing this in Project?

Many thanks

Josh

RE: Viewing tasks

A simple way would be to use OLE to link cells in Excel to the relevant cells in a new Project file. Do this for both your Excel views - you will end up with two Project files. Then incorporate both into a new master file by using Insert Project in the task name column.

Use Excel as usual - the changes you make in Excel will reflect in your new Project files and in the master.


 

MS Project tip:

Set default task type - Project 2010

a. In Project, click on the File tab
b. Select Options from left hand side
c. Click on Schedule to set the scheduling options
d. Set the Default Task type box to your chosen option
i. Generally if you plan/estimate your projects using durations you should use fixed duration, and untick the box New tasks are effort driven, if you plan/estimate with person hours use fixed work, or for plans estimated with the proportion of resources time use fixed units, and untick the box New tasks are effort driven)
e. Click OK to apply your changes

View all MS Project hints and tips


Server loaded in 0.09 secs.