Importing information from excel

The UK's most regular instructor-led training courses.
Training information: ms project training courses · Project training · Microsoft Project Training uk
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

Resolved · Low Priority · Version Standard

Steph has attended:
Project Intro Intermediate course

by - delegate Steph [1 post] (2008 Mar 28 Fri, 14:24) Reply

Is there an easy way to import information from Excel or Word?

Version	Date	Location	Places available	Book	Next place rate:
Project Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 24 Mon + 25 Tue	Southwark	4	book now	£475	£485
2007	2008 Nov 27 Thu + 28 Fri	Bayswater	0	FULL
2007	2008 Dec 8 Mon + 9 Tue	Bloomsbury	0	FULL
2003	2008 Dec 9 Tue + 10 Wed	Bayswater	6	book now	£335	£365
2007	2008 Dec 11 Thu + 12 Fri	Bloomsbury	1	book now	£490	£495
2003	2008 Dec 18 Thu + 19 Fri	Southwark	7	book now	£345	£399
Full Schedule: See all 55 Project Intro Intermediate course dates. Bookings currently available until 26th November 2009.

RE: Importing information from excel

by - trainer Alan silver contributer [73 posts] (2008 May 18 Sun, 17:52) Reply

Use OLE to link Excel cells to the relevant table cells in a new Project file.

The data will be live linked so changes to Excel will update the Project.

Our advanced course goes into this and more.

· Advanced Microsoft Project Training - manage your level of expertise
· Discover Microsoft Project 2003
· Why Very Small Businesses Benefit from Microsoft Project Training Seminars
· Microsoft Project Server vs. Microsoft Project
· Managing multiple projects with MS project

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

Project tip:

Format individual bars on your GANTT chart

To draw attention to a bar on your Gantt chart simply double click it. From the dialogue box that opens make your selection of text and bar modifications.

View all Project hints and tips