Importing Progress Data from excel

[frankcdaly]

I was wondering if anybody has figured a way to import progres
information from an excel spreadsheet? I am working on Microsof
Project Professional 2007 and Excel 2007. Every week i would like t
update % work complete from various project leaders' progress summar
sheets which are produced in excel (necessary as per custome
specification). There are thousands of tasks per project and a larg
number of projects in progress at any one time, however, if there was
way to automatically update or synch the % work complete column wit
their equivalent cell in an excel spreadsheet it would make this tas
possible.

Any help or opinions would be much apreciate

 

[JulieS]

Hello frankcdaly,

You can certainly export data from Project into an Excel file, change
data and then merge the data back into Project. However, there is a
problem with doing this in Project 2007, so I would not recommend
attempting this currently.

The big picture steps are to export the Project data to Excel making
sure you capture the fields you need to export. I suggest including:

Task Unique ID
Name
Actual Start
Actual Finish
Actual Duration
Remaining Duration

You can then update the data in Excel by changing Actual and Remaining
Duration or adding an Actual Finish date. By modifying actual and
remaining duration, project will recalculate the % Complete. Setting
an actual finish date will set the task as 100% complete.

You would then open the Excel file in Project and merge the changed
data, using the Task Unique ID as the merge field.

As I said, there is a bug which prevents this from working correctly
right now.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[frankcdaly]

Hello ulie,

Thank you for the information all the same, i attempted what you
described but as you said there is still a bug that arises which is a
shame. Thank you for your input anyway.

 

[JulieS]

You're welcome frankcdaly and thanks for the feedback.

Julie