Loading...
Quick Links

Updating MS Project/PWA from Excel

Home Forums Discussion Updating MS Project/PWA from Excel

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #408262 Reply

    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?

    Thanks..

    #408265 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    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 Reply
    Larry Christensen
    Guest

    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 3 posts - 1 through 3 (of 3 total)
Reply To: Updating MS Project/PWA from Excel
Your information: