How to link Project and Excel in real time

%3CLINGO-SUB%20id%3D%22lingo-sub-1354895%22%20slang%3D%22es-ES%22%3EHow%20to%20link%20Project%20and%20Excel%20in%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354895%22%20slang%3D%22es-ES%22%3E%3CP%3EThe%20question%20is%20simple%3A%20I%20would%20like%20to%20connect%20a%20Project%20(Gantt%20view%20table)%20with%20Excel%20and%20the%20see%20the%20changes%20in%20real%20time.%20At%20present%2C%20I%20am%20using%20the%20extraction%20from%20Project%20to%20Excel%20but%20it%20is%20quite%20slow%20and%20not%20in%20real%20time.%3C%2FP%3E%3CP%3EMoreover%2C%20if%20it%20is%20possible%20to%20do%20the%20opposite%20thing.%20Connect%20excel%20to%20project%20to%20add%20new%20dates%20and%20information%20(in%20my%20case%2C%20real%20dates%20and%20percentage%20of%20completed%20tasks).%20I%20was%20thinking%20about%20hyperlinks%2C%20but%20if%20it%20is%20to%20transfer%20too%20much%20information%2C%20will%20it%20give%20too%20many%20errors%3F%20So%20if%20there%20is%20a%20more%20reliable%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1354895%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355851%22%20slang%3D%22pt-BR%22%3ERe%3A%20How%20to%20link%20Project%20and%20Excel%20in%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355851%22%20slang%3D%22pt-BR%22%3ESir%20PMA85%2C%3CBR%20%2F%3EIf%20you%20give%20more%20attention%20to%20Project%20funciontions%2C%20may%20you%20do%20not%20need%20to%20use%20the%20Excel.%20%3CBR%20%2F%3EYou%20could%20explorer%20the%20relatories%20to%20build%20one%20specific%20to%20your%20end.%20%3CBR%20%2F%3ESo%2C%20this%20is%20my%20simple%20and%20own%20opinion.%20Explore%20it%20and%20you%20will%20can%20do%20more.%20%3CBR%20%2F%3ECheers%2C%20cheers!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1364493%22%20slang%3D%22es-ES%22%3ERe%3A%20How%20to%20link%20Project%20and%20Excel%20in%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1364493%22%20slang%3D%22es-ES%22%3E%3CP%3EThank%20you%20for%20your%20advice%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303748%22%20target%3D%22_blank%22%3E%40marciusmgsouza%3C%2FA%3E%20.%20But%20really%2C%20Project%20is%20not%20prepared%20for%20so%20many%20restrictions%20dates%20and%20relations%20between%20tasks.%20Sometimes%20a%20task%20cannot%20coincide%20with%20another%20one%2C%20so%20it%20is%20successor%20and%20predecessor%20at%20the%20same%20time%2C%20and%20there%20are%20other%20dates%20acting%20as%20restrictions%20involved%20for%20the%20same%20task).%20So%20I%20need%20the%20support%20of%20Excel.%20I%20guess%20it%20will%20be%20solved%20by%20VB.%20But%20I%20do%20not%20the%20language.%20If%20there%20is%20someone%20able%20to%20help%2C%20it%20will%20be%20very%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406486%22%20slang%3D%22pt-BR%22%3ERe%3A%20How%20to%20link%20Project%20and%20Excel%20in%20real%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406486%22%20slang%3D%22pt-BR%22%3E%3CP%3EDear%20Mr%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F644732%22%20target%3D%22_blank%22%3E%40PMA85%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20tasks%20(more%20than%20one)%20can%20be%20operate%20at%20the%20same%20time.%20And%20the%20Project%20alert%20you%20if%20you%20use%20the%20same%20resource.%20%3CBR%20%2F%3E%20So%2C%20quite%20all%20the%20time%2C%20when%20I%20go%20to%20find%20a%20limit%2C%20most%20of%20those%20points%20are%20unknonwed%20of%20the%20funciont%2C%20or%20possibility.%3C%2FP%3E%3CP%3EAnyway%2C%20I%20wish%20you%20find%20your%20solution%20as%20soon%20as%20possible.%3C%2FP%3E%3CP%3EAll%20the%20best%20to%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

The question is simple: I would like to connect a Project (Gantt view table) with Excel and the see the changes in real time. At present, I am using the extraction from Project to Excel but it is quite slow and not in real time.

Moreover, if it is possible to do the opposite thing. Connect excel to project to add new dates and information (in my case, real dates and percentage of completed tasks). I was thinking about hyperlinks, but if it is to transfer too much information, will it give too many errors? So if there is a more reliable way.

 

Thank you in advance.

3 Replies
Highlighted
Sir PMA85,
If you give more attention to Project funciontions, may you do not need to use the Excel.
You could explorer the relatories to build one specific to your end.
So, this is my simple and own opinion. Explore it and you will can do more.
Cheers!
Highlighted

Thank you for your advice @marciusmgsouza . But really, Project is not prepared for so many restrictions dates and relations between tasks. Sometimes a task cannot coincide with another one, so it is successor and predecessor at the same time, and there are other dates acting as restrictions involved for the same task). So I need the support of Excel. I guess it will be solved by VB. But  I do not the language. If there is someone able to help, it will be very appreciated.

 

Highlighted

Dear sr @PMA85 

The tasks (more than one) can be operate at the same time. And the Project alert you if you use the same resource.
So, quite all the time, when I go to find a limit, most of those points are unknonwed of the funciont, or possibility.

Anyway, I wish you find your solution as soon as possible.

All the best to you!