Excel import into MS Project 2016 with regular intervals

Home Forums Microsoft Project Discussion Forum Excel import into MS Project 2016 with regular intervals

Viewing 2 reply threads
  • Author
    • #479272

      Hi All,

      Please can you assist.
      My company is working on a project where each department uses excel to provide feedback to my team.
      Is there a way in which they can continue to update their excel docs, but allow my team to use MS Project to update the project plans.
      I have tried the importing function in MS Project, but the mapping does not seem to be very accurate.
      The question i have is that, do we need any additional tools to map to correctly to import? Does MS Project server resolve this?
      What are my options?
      Thanking in advance

    • #479274
      Avatar photoJigs Gaton

      I think that’s an excellent question, unfortunately (from my experience), u need a custom macro designed for your setup. Ive never seen the 2016 (or 2019) standalone version successfully import and export sheets with precision, unless u hire someone to make it so. But I’ve been retired a few years now… perhaps there is a younger solution.

    • #482781

      May be this can help you.
      This is for a dektop version only
      kind regards,

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