MSP: Remaining work - Time Phased

Submitted by Kayode Oni on
Microsoft Project

Member for

22 years 9 months
Member for 22 years 9 months
Submitted by Alexandre Faul… on Fri, 2009-05-22 04:22
Permalink

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

Member for

18 years 5 months
Member for 18 years 5 months
Submitted by Kayode Oni on Wed, 2009-05-20 07:58
Permalink

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.

Member for

18 years 2 months
Member for 18 years 3 months
Submitted by L.E.N. Lewis on Tue, 2009-05-19 10:39
Permalink

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.