Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

MS EXCEL

12 replies [Last post]
Tue, 2008-12-23 08:37
Samad Mohd Abdul
User offline. Last seen 14 years 21 weeks ago. Offline
Joined: 29 Dec 2005
Posts: 14
Groups: None
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
Top

Replies

Tue, 2009-03-03 09:33
#1
Kharadi Shadab
User offline. Last seen 16 years 14 weeks ago. Offline
Joined: 12 Feb 2009
Posts: 7
Groups: Civil Engineering
Raviraj Bhedase,

Thank you very much.

Regards
Azeem
Top
Tue, 2009-03-03 07:38
#2
A D
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
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
Top
Tue, 2009-03-03 07:17
#3
Abdul Khadeer
User offline. Last seen 13 years 1 week ago. Offline
Joined: 11 Sep 2004
Posts: 32
Groups: None
Dear Ravi,

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

Thanks

AK
Top
Tue, 2009-03-03 06:53
#4
Kharadi Shadab
User offline. Last seen 16 years 14 weeks ago. Offline
Joined: 12 Feb 2009
Posts: 7
Groups: Civil Engineering
MR Raj,

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

Regards
Azeem
Top
Wed, 2009-02-25 08:37
#5
Floren Pal Lagasc...
User offline. Last seen 16 years 18 weeks ago. Offline
Joined: 24 Dec 2008
Posts: 4
Groups: Civil Engineering, GPC Qatar
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
Top
Wed, 2008-12-24 14:07
#6
Ali Farhat
User offline. Last seen 15 years 2 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
Hi Ravi, could this be applied to P6 too?
Top
Wed, 2008-12-24 12:04
#7
A D
User offline. Last seen 4 years 35 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
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
Top
Wed, 2008-12-24 09:16
#8
Samad Mohd Abdul
User offline. Last seen 14 years 21 weeks ago. Offline
Joined: 29 Dec 2005
Posts: 14
Groups: None
hi zakaria,

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

thanks and regards
Top
Wed, 2008-12-24 04:11
#9
Colin Blair
User offline. Last seen 34 weeks 6 days ago. Offline
Joined: 22 Apr 2004
Posts: 29
Groups: None
Sorry for the confusion

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

Regards

Colin
Top
Wed, 2008-12-24 02:17
#10
Izam Zakaria
User offline. Last seen 8 years 31 weeks ago. Offline
Joined: 28 May 2006
Posts: 221
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
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
Top
Tue, 2008-12-23 10:29
#11
Colin Blair
User offline. Last seen 34 weeks 6 days ago. Offline
Joined: 22 Apr 2004
Posts: 29
Groups: None
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
Top
Tue, 2008-12-23 09:35
#12
Ali Farhat
User offline. Last seen 15 years 2 weeks ago. Offline
Joined: 23 Oct 2008
Posts: 120
Groups: None
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.
Top