Link between Project and Excel

Home Forums Microsoft Project Discussion Forum Link between Project and Excel

  • This topic has 3 replies, 3 voices, and was last updated 4 years ago by Anderson Cezar de Menezes.
Viewing 3 reply threads
  • Author
    • #406800

      Is it possible to link data between Ms Project and Ms Excel? If yes how?

    • #406802
      Jigs Gaton

      True linking? Not easy, but there is this: – but I’ve never had much luck with it. And I’ve not seen an add-in lately that works either 🙁

    • #406803
      Larry Christofaro

      Jigs has a good point. Question for you is what you mean by linking data between Project and Excel. If you are looking for a dynamic link between the two applications, that doesn’t exist. There is a feature that allows you to import or export to/from Project and Excel if that works. One MPUG article from Ellen Lehnert is here: There are also other description online. Hope that helps…

    • #416542
      Anderson Cezar de Menezes

      As Jigs says, there is “some” connection.
      You can copy-paste as a link.
      It works in both ways, the huge issue is the refresh rate.
      For example, I tried to use it to send and retrieve data from excel to be calculated in MS Project. It works, but when I tried to use Crystal Ball in Excel, to simulate scenarios, I had to do it “step by step”, because the changes in Excel are very fast, and the return for the results in MS Project has a “delay” that makes impossible to work with those numbers in a fast way.

Viewing 3 reply threads
  • You must be logged in to reply to this topic.