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)
I created a simple 15 line plan to try to get this to work, and would appreciate any help.
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.
|Tags: excel, project 2007, service pack 2|
|Thread Tools||Search this Thread|
|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|