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

software

ResolvedVersion 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:

Show or hide toolbar ScreenTips

On the Tools menu, go to Customize, and then select Toolbars.
Click the Options tab.
put a tick or remove the tick from the Show ScreenTips on toolbars check box.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.