Updating MS Project/PWA from Excel

Home Forums Microsoft Project Discussion Forum Updating MS Project/PWA from Excel

  • This topic has 2 replies, 3 voices, and was last updated 6 years ago by Larry Christensen.
Viewing 2 reply threads
  • Author
    • #408262

      Hello, the Project Online system (PWA) has been designated to be the system that holds all project information. However, one of our departments does not want to participate and would rather stay in Excel to track their work. I need to use their Excel data to update their projects in PWA. Does anyone know how to do that?


    • #408265
      Avatar photoLarry Christofaro

      This might be a bit outside the box but maybe the best solution is to allow them to keep their schedules in Excel. Create a Project Type for them that doesn’t display the schedule tab will allow them to track projects but with no schedule. If they save their Excel task list in SharePoint you could add a field for “Excel Tasks URL” that will give others a path to the document. Hope that helps…

    • #408332
      Larry Christensen

      Thanks Larry.
      We are in need of track a few milestones for the projects in that SPI has been introduced to the organization.
      I do find your idea quite interesting but I may need to have a few items loaded into PWA to address out KPI (SPI).

      Thank you for the reply. It is appreciated.

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