Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Viewing tasks

Resolved · Medium Priority · Version 2003

Reply 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

For upcoming training course dates see: Pricing & availability

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

MS Project articles

· Using Project 2010 With Excel 2010
· A Project Shared Is A Project Improved
· Understanding Task Relationships In Microsoft Project
· Microsoft Project Professional At A Glance
· A Solid Project Plan for Success

Please browse our web site to find out more about
ms project server consultancy and other Microsoft training courses.

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