none
Issue while exporting Project Plan to excel in project online RRS feed

  • Question

  • I have a PWA in project online.Over there when i go to projects and open a project and select the export to excel option in Project Plan. The data is exported to excel but the indentation is not properly means that the plan is exported in excel but indent and outdent is now done properly when export to excel.Is there any solution for that or is there any macro for that.Currently i am using using project online 2016 and excel 2010.
    Tuesday, December 6, 2016 2:33 AM

Answers

  • Hi Ashish,

    This is actually how it works. The export to Excel cannot render any formatting. A workaround would be to add the outline level in the project view and to export it to excel. Then with this outline level, you could recreate the indentation in excel, manually or with a macro.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, December 6, 2016 8:11 AM
    Moderator