P3 TO EXCEL... URGENT

C
Claus Wellendorf 👤 Member for 19 years 7 months

Summary activities can also be made as "WBS type" activities and exported as normal activities to excel. That is of course if you use wbs structure in your project and not only coding

E
ESSAM RUSHDI 👤 Member for 20 years 3 months

To transfer summary tasks with activites:



Activity codes should be exported with activities.



then you can finalized in Excel.



Essam Rushdi

A
Amri Mansor 👤 Member for 24 years 6 months



Try use the following function.



=min( ) for start date



and



=max( ) for finish date.



Amri

S
Santosh Bhat 👤 Member for 21 years 1 month

Your "summary tasks" are not in fact tasks at all, but just the organisational summaries. They cannot be exported.

M
musawar Shaikh 👤 Member for 19 years 8 months

Thank you for quick reply.

With the guidance of you I figured out p3 to excel . But still I am unable to transfer summary tasks with activites.

Is it possible? to transfer summary task with activities??

E
Eugene K 👤 Member for 19 years 7 months

Tools/Project Utility/Export...

select WHAT u wnat to export

remember to export in WK1 format.



MS Excel can open WK1 files.



but read in a thread that says MS Excel 2007 CANNOT open wk1.

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts