software

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

Forum home » Delegate support and help forum » Microsoft Project Training and help » Software

Software

resolvedResolved · Low Priority · Version 2007

Robert has attended:
Project Intro Intermediate course

Software

What is the most affective way to get info from Excel to project

RE: Software

Hi Robert,

Thank you for your question.

There are a couple of ways. If the data in Excel is arranged in columns and includes data like task names and durations, you can copy and paste the data directly into your project file in the task sheet.

The second way is to use the File Open command and navigate and choose the excel file you want. You will then get the Import wizard and you will have to map the fieldnames in the spreadsheet with the relevant field names in Project.

I hope this answers your question.

Regards

Simon


 

MS Project tip:

Avoid Accidental Constraints

The initial default table is the Entry table. Enter a task name and duration, but do not enter start or finish dates. Form the plan using links, predecessors. Typing dates introduces constraints. To remove these constraints, double click on a task, and on the Advanced page of Task Information set the constraint back to As Soon As Possible (all other options are there too.)

View all MS Project hints and tips


Server loaded in 0.09 secs.