Organise the Data
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
Save it as WK1 files.
Wk1 files can be opened in Excel 2003.
Cheers,
Raviraj
Hi RaviRaj,
I have followed the above steps but when it comes to path selection it shows ASCI, DBASE Lotus no any EXCEL I have installed the ExcEl 2003 too..
Gayantha
Excel 2007 doesnt support WK1 extension. U need to use Excel 2003 for import / export.
Now I know
You are using P5 but the main thread is P3.
Oooppppss????
My idea refer to P3 and exporting to excel 2003.
Previously, the path I used was outside P3OUT and it did not worked.
so to make it safe and avoid unnecesary waste of time, I used the path to P3OUT for export and import
Dear All
I am working in excel 2007 which version i have to use Primavera 5 or else I have to switch to excel 2003 Advice me...
Gayantha
I believe, the file can be saved anywhere and not limited to P3 out.
Hav u tried saving anywhere else and u got problem???
Cheers,
Ravi
Gaya,
The steps are found in P3 Manuals.
I think you got stuck in the path.
Your path should be limited only to P3OUT
Go to Tools --> Project Utilities --> Export
In the window there will be three tabs, Content, Format and selection.
In selection,
type in the activity decription for selection,
Give path name for the file location in Format
And Content list in CONTENT tab.
Open this excel file and then edit whatever u want and save it.
Go back to P3 and then go to Tools --> P.... U....--> Import and then just give the excel file location and say RUN.
Remember, this doesnt work in Excel 2007.
Cheers,
Ravi
Dear Raviraj,
I tried to export it in to excel but it didnt work can you please send me the steps of doing it
thanks
Gayantha
Or otherwise, you can can export them into excel and then change the activity description and import it back.
Cheers,
Ravi
Hi Alexandre,
Thanks a lot for the tip it helps me lot
cheers
GA
Hello,
sort your data on activity description,
key in the new activity description on the firts row,
select all the rows down on this particular column,
click Edit, Fill Cell
sort your data back to the orignial order
Alexandre
Hi gentleman,
I want change the activity description repeated more than 100times in the programme each time it has a different ID but I want to change the Activity description in to new one which will be same for all places.....
Please help me send me the steps
GA
Hi Wael,
Thankyou so much Its helped me lot
Gayantha
update each activity you want with the proper dicipline . you will use to code the activities by means or project area and then filter them up on your new codes. go to data>activity ID> and see what diciplines you have. then arrange to see the levels set to your project and then filter or organize up on that criteria.
i hope i was useful ... but as far as i know that is the way to do it.