Skip to content
ProjectControls.com
Microsoft Project

MSP: Remaining work - Time Phased

In the Open Standard
Kayode OniMember for 19 years 5 months
Created
5
5
0
Hi guys,
Does anyone know how to import time phased remaining work to excel.(In a progressed project with actual work and remaining work)

I currently use MSP 2K3 and it is not listed as one of the fields that can be exported using the export time phased data function.

Thanks guy
Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    L.E.N. Lewis ·
    #1
    Import or export?

    You can export timescaledata from Project (and load it into Excel). Or, from a different vantage point, you can import into Excel data exported from Project.

    You cannot export timescaledata from Excel (and load it into Project). Or, from a different vantage point, you cannot import into Project data exported from Excel. (Well, you can but it’s not easy.)

    Display the Analysis toolbar
    Click on "Analyze TimeScaled Data in Excel"
    Answer the various prompts.
    Report
  2. 0
    Kayode Oni ·
    #2
    Hi Lewis.
    Apologies for confusion, It should read: Export time phased data from MS Project to MS Excel.
    I have used the analyze timescaled data tab, but the data I want is not included in available list.
    Report
  3. 0
    L.E.N. Lewis ·
    #3
    What data do you want?
    Report
  4. 0
    Alexandre Faulx-Briole ·
    #4
    Kayode,
    you cannot export any other data that are not included in the list "Export Timescaled Data in Excel"
    another way is to show the Using Tasks view, display the fields you want in the distribution (rightmost) pane, and select the necessary data to paste in Excel
    Alexandre
    Report
  5. 0
    Kayode Oni ·
    #5
    Thanks Alex, I will give that a try.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?