Skip to content

MS EXCEL

Samad Mohd AbdulMember for 20 years 9 months
Created
12
5
0
Hi All,

Does anybody knows how to link a cell in Microsoft excel to Primavera, so that the data in excel sheet should get automatcially updated whenever we update the primavera programme.

With Best Regards,

Mohd Abdul Samad

12 replies

Oldest first
  1. 0
    Ali Farhat ·
    I believe it is not possible. you have to export in excel format the data you need. the max you can do is set a template for that.
  2. 0
    Colin Blair ·
    Hi

    Copy the required cell in MS Project. Then, in Excel select
    Edit / Paste special
    Select
    Paste link
    Select
    text

    Be cautious - If file name or directory gets change - it will could corrupt files

    Let me know if this helps


    Colin
  3. 0
    Izam Zakaria ·
    I’ve that excell templates....pls do not hesitate to get it from me... I can be contacted via my email aizam.zakaria@sbmoffshore.com
  4. 0
    Colin Blair ·
    Sorry for the confusion

    I’ve just re-read your post - My solution is for MS Project and not P3

    Regards

    Colin
  5. 0
    Samad Mohd Abdul ·
    hi zakaria,

    Could you please forward a copy to my email samadmohdabdul@yahoo.com.

    thanks and regards
  6. 0
    A D ·
    Thats possible,

    use pervasive ODBC Drivers. Can download from primavera website

    If u update p3 files, excel file will get updated by just clicking refresh button. U can prepare tables as u want.

    Cheers,

    Rav
  7. 0
    Ali Farhat ·
    Hi Ravi, could this be applied to P6 too?
  8. 0
    Floren Pal Lagasca Tabbal ·
    izam zakaria,

    please send me a copy of your MS Excel template.

    here is my email add: mibtree@yahoo.com

    Thank you very much.

    Floren Pal
  9. 0
    Kharadi Shadab ·
    MR Raj,

    Could U plz advise me for downloading the pervasive ODBC Drivers from Primavera site... Or any hints Plz..

    Regards
    Azeem
  10. 0
    Abdul Khadeer ·
    Dear Ravi,

    can you advise me the same for P6. It will be of great help.

    Thanks

    AK
  11. 0
    A D ·
    Hi Shadab / Abdul,

    Unfortunately, these pervasive odbc drivers are removed from primavera’s ftp site as of now.

    I have never heard of using it with P6.

    Paul harris has written a paper on using pervasive drivers and thats the best source for understanding the concept.

    U can check on his website at www.eh.com.au

    Cheers,

    raviraj
  12. 0
    Kharadi Shadab ·
    Raviraj Bhedase,

    Thank you very much.

    Regards
    Azeem

Log in or join to reply

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

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