importing information excel

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

Forum home » Delegate support and help forum » Microsoft Project Training and help » Importing information from excel

Importing information from excel

resolvedResolved · Low Priority · Version Standard

Steph has attended:
Project Intro Intermediate course

Importing information from excel

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

RE: Importing information from excel

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.


 

MS Project tip:

Autofit column width – Project (all versions)

At the top of the columns where each column name is located (Task Name, Duration, etc.), hover over the vertical column line which you want to move.

A short bold vertical line will appear, with horizontal arrows pointing left and right.

Left click and hold this icon and it will permit you to grab the column line, allowing you to move it left or right to your desired location.

View all MS Project hints and tips


Server loaded in 0.07 secs.