Forum Discussion

Smeac81's avatar
Smeac81
Copper Contributor
Apr 30, 2024

Maintain format when exporting Project to Excel

After successfully exporting Project (MS Project Online Desktop Client v2403) to Excel (MS 365 Apps for Business v2403) using the Export tool, all of the data is present but the format has been simplified.  The Tasks are no longer indented from the Summaries making it difficult to follow the flow of the project.  The Summaries in Project are bold but in the Excel export, the bold feature is gone.  Any way to maintain the formatting that Project has in the Excel export?  I can fix it manually but with 500+ line itmes, that is a chore.

  • Smeac81 

    Yeah, I've got what you want/need and it is a macro I wrote a few years ago.

    If you are interested, contact me at the address below.

    John

    jmacprojataticlouddotdotcom

    (remove obvious redundancies)

  • John-project's avatar
    John-project
    Silver Contributor

    Smeac81 

    Yeah, I've got what you want/need and it is a macro I wrote a few years ago.

    If you are interested, contact me at the address below.

    John

    jmacprojataticlouddotdotcom

    (remove obvious redundancies)

Resources