1

I am trying to export the weekly tasks from MS project into Excel where the team can update the hours worked and remaining effort Is there a way by which i can import it back into the MS Project and it updates the tasks I remember in my previous projects we used to do that but dont quite rememeber the mechanics of it Help on this or any alternatives would be greatly appreciated thanks! Ravi.

2

I will be out of the office starting 23/12/2005 and will not return until
16/01/2006. I will respond to your message when I return.
If you have any any queries you can call Andrew Gribble on 9422 4117

This email is intended solely for the use of the addressee
and may contain information that is confidential or privileged.
If you receive this email in error please notify the sender and
delete the email immediately.

//*------------ RELATED WHITE PAPERS --------------
Ending the Branch Office E-mail Tradeoff
http://www.ittoolbox.com/r/da.asp?r=127255

--------------------------------------------------*//

3

OK…I’m intrigued, but not able to duplicate this with the information provided. Can you specify what fields your are exporting in the MAP?

4

in a groups database page i would have 2 columns “hours today” and then
“total hours” and
excell could calculate the “total hours” if i did not want to .

“have you written your own operating system yet ?”

From: “Ravi via ms-project-l”

5

Thanks to the responses from richmepk i was able to successfully export and import back tasks from MSP using Maps

When i import back from MSExcel the project tasks are getting updated to a contraint of “Finish No Earlier Than” … so if i have to increase the task duration it messes up the whole project.

The only change i am making in excel is the hours worked and hours remaining

What do i need to do during the import to make sure it dosent do that

thanks !

R

6

That would be swell… an example would help a lot

Here is my email address ravi_bhogaraju@hotmail.com

thanks a lot !

7

Hi Mr.Ravi,
INstead doing all this u can use save as function instead.
Save the project file in excel format. And do necessary
modifications.Andopen the excel file. I think this must solve u r
problem. I am wrong please
correct me.

Thanks and Regards,

On 12/17/05, rpm via ms-project-l

8

Interesting technique. May I have the example as well.

Thanks

Rob Rowan

Project Management Consultant

*: Phone: 011 432 3522 =20

=C5: Cell: 084 335 4837 (084-DELIVER)

*: Fax: 011 432 3522

*: e-mail: rpm@mweb.co.za =20

9

Yes they MAP technique allows you to do what you want. There is a =
“merge”
capability which will do this. If you included your email addy I can =
send
you an example of how to do this.=20

10

thanks for this tip…

Just to elaborate a bit more on the issue… i dont want to import new tasks but just want to import back the worked hours and remaining hours for tasks that are existing in the plan

Can this be achieved by Maps as well…

In the past when i have tried to import from excel it appends the import to the existing plan as new tasks

11

Yes you can easily do this. Project has a technique called MAPs which allows
this. Just open the Project and then click FileOpen again. Select the XLS
that has the update information. A Wizard will appear which walks you
through the process of getting the task updates applied to the project. You
can Save the MAP so that in the future you can simply apply the MAP