Thu 3 Apr 2008, 10:23Delegate Josh said...
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
Sun 18 May 2008, 17:20Trainer Alan said...
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.
