Hi All, Is it possible to Link Project to Excel and Vice versa (cell)??? I'd like to "synchronise data between MS Excel and MS Project?? If I Copy and Past as a link it will work only in one way right??? Thank you so much Cheers Vit
Yes one way only, but it is not recommended. The DDE links are fragile and if you over-write, move or rename either file you may corrupt one or both files. Options are exporting then importing data or using VBA. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "Vit" wrote in message news:95d87767-8c2b-44e6-aaf5-865d2f7f992f@n33g2000pri.googlegroups.com... Hi All, Is it possible to Link Project to Excel and Vice versa (cell)??? I'd like to "synchronise data between MS Excel and MS Project?? If I Copy and Past as a link it will work only in one way right??? Thank you so much Cheers Vit
If using PS07, you could also do this a number of other ways including VSTO to the PSI, DocLib events to the PSI, etc. -- Stephen Sanderlin Principal Consultant MSProjectExperts For Project Server Consulting: http://www.msprojectexperts.com For Project Server Training: http://www.projectservertraining.com Owner/Founder - EPMFAQ http://www.epmfaq.com/ http://forums.epmfaq.com/ Rod Gill wrote: > Yes one way only, but it is not recommended. The DDE links are > fragile and if you over-write, move or rename either file you may > corrupt one or both files. > > Options are exporting then importing data or using VBA.
