Forum Discussion
Solved
How to import a Project for the Web export into Project Pro (desktop)
Hi all, so I'm working with someone who is using Project for the Web. This will only allow them to export to excel. I'm trying to take this and import it into my desktop Project Pro, but can't seem t...
- wolfie42 --
I ran into this exact problem a couple of years ago, and decided it is way too much work trying to import into Microsoft Project an Excel workbook that was exported from Project for the Web. However, if this something you absolutely have to do, then copy all of the cells from the exported Excel workbook (including the column names) and then paste them into a competely new Excel workbook. Then save the new workbook. You should now find that the information appears as expected in the Import dialog in Microsoft Project. Hope this helps.
wolfie42 --
I ran into this exact problem a couple of years ago, and decided it is way too much work trying to import into Microsoft Project an Excel workbook that was exported from Project for the Web. However, if this something you absolutely have to do, then copy all of the cells from the exported Excel workbook (including the column names) and then paste them into a competely new Excel workbook. Then save the new workbook. You should now find that the information appears as expected in the Import dialog in Microsoft Project. Hope this helps.
I ran into this exact problem a couple of years ago, and decided it is way too much work trying to import into Microsoft Project an Excel workbook that was exported from Project for the Web. However, if this something you absolutely have to do, then copy all of the cells from the exported Excel workbook (including the column names) and then paste them into a competely new Excel workbook. Then save the new workbook. You should now find that the information appears as expected in the Import dialog in Microsoft Project. Hope this helps.
Thanks Dale! Will give this a try first thing in the AM. Been reading up on this "light" version of Project and looks like MS's hope is for it to become more robust but still a little shocked you can't export as an mpp file. Unfortunately this file is coming from a small vendor and while we've requested they upgrade, not sure that's going to happen. 😕