ms project import

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

Forum home » Delegate support and help forum » Microsoft Project Training and help » MS PROJECT 2010 IMPORT TO EXCEL

MS PROJECT 2010 IMPORT TO EXCEL

resolvedResolved · Low Priority · Version 2010

Vanita has attended:
Project Intro Intermediate course

MS PROJECT 2010 IMPORT TO EXCEL

Please can you let me know how to import the excel sheets into MS proj 2010

Thanks
Vanita

RE: MS PROJECT 2010 IMPORT TO EXCEL

Hi Vanita,

Thank you for your question.

To start the Import Wizard you need to follow these steps:

1. Go to File and Open.
2. Select Excel Workbook from File Types and select the Excel workbook and click Open.
3. This will start the Import Wizard and follow the steps through.
4. When you get to the Task mapping screen you need to choose which worksheet contains the data you want in project.
5. You then need to choose and map the fields from Excel into Project fields.

I hope this answers your question.

Regards

Simon

Sun 5 Dec 2010: Automatically marked as resolved.


 

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.08 secs.