Results 1 to 2 of 2

Thread: Updating actual and remaining work from Excel not updating properly

  1. #1
    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.

  2. #2
    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

Similar Threads

  1. Images fails to load properly after updating Firefox 12
    By ameesha in forum Technology & Internet
    Replies: 2
    Last Post: 20-05-2012, 05:47 PM
  2. Excel 2007 charts are not updating at all
    By Omkaari in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 02:12 PM
  3. Mouse not working properly after updating Kaspersky
    By Meditation in forum Networking & Security
    Replies: 5
    Last Post: 05-12-2011, 04:43 AM
  4. Computer not working properly after updating Windows XP.
    By Judah in forum Operating Systems
    Replies: 4
    Last Post: 27-06-2011, 08:59 AM
  5. Replies: 5
    Last Post: 23-01-2011, 10:17 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,637,331.33387 seconds with 17 queries