Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Updating actual and remaining work from Excel not updating properly

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-02-2012
Member
 
Join Date: Feb 2012
Posts: 1
Updating actual and remaining work from Excel not updating properly

I am using MS Project 2007, SP2, and I'm trying to update actual and remaining work on assignments through an excel 2007 import (using xls format). I started by exporting the assignments from the project into excel, with the Assignment Unique ID to be used as the MergeKey, and then updating the resulting excel spreadsheet with new info to be brought back into Project.

When I do the merge (not append), the actual work and remaining work do not update. If I do an append, new assignments actually do get created.

The fields that I am using for the update are:
Unique_ID (which is the assignment ID)
Task_Unique_ID
Resource_Unique_ID
Resource_Name
Actual_Work
Remaining_Work
Work

I created a simple 15 line plan to try to get this to work, and would appreciate any help.

Reply With Quote
  #2  
Old 13-02-2012
Member
 
Join Date: Dec 2006
Posts: 489
Re: Updating actual and remaining work from Excel not updating properly

Try the export/import without the work field -- use only Actual and Remaining Work and see if that helps.

Julie
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Updating actual and remaining work from Excel not updating properly"
Thread Thread Starter Forum Replies Last Post
Images fails to load properly after updating Firefox 12 ameesha Technology & Internet 2 20-05-2012 05:47 PM
Excel 2007 charts are not updating at all Omkaari MS Office Support 2 24-01-2012 02:12 PM
Mouse not working properly after updating Kaspersky Meditation Networking & Security 5 05-12-2011 04:43 AM
Computer not working properly after updating Windows XP. Judah Operating Systems 4 27-06-2011 08:59 AM
Sony Ericsson Xperia x10 not functioning properly after updating to 2.1 Android Techie Boy Portable Devices 5 23-01-2011 10:17 AM


All times are GMT +5.5. The time now is 03:10 PM.