Copying from MSP to Excel - Black Cells RRS feed

  • Question

  • All, 

    When copying cells from MSP to Excel I very often get black filled cells appearing in Excel, more precisely the whole line that I copy is black. The contents of the cell is intact and the formatting of the cell also, e.g. I have black and blue text in these cells and the text stays the same. I then have to scroll the 1000 lines or so and manually make all the black cells 'no fill'. 

    Does anyone know the root of the problem? and how to stop this happening?

    Many thanks


    Wednesday, January 8, 2014 9:36 AM

All replies

  • Hi,

    We would need more information. 

    • Which Project version/SP do you have?
    • Which columns are you copying?
    • Do you have any formatting in your Project file?
    • Did you try to export the file to excel instead on doing a copy/paste?

    Note that copy/paste is never recommended talking about MS Project, since it can trigger strange behavior, even corrupt the file. I would recommend to use the export MS Project functionality.

    Please give us more detail and we'll be pleased to help you.

    Guillaume Rouyre - MBA, MCP, MCTS

    Wednesday, January 8, 2014 3:04 PM