none
Can you use Excel 2013 with Project Professional 2010 to build visual reports RRS feed

  • Question

  • I am using Project Server 2010 SP2 patched to April 2014 same with Project Professional 2010. When I open Visual Reports for a project in professional a popup message appears stating the I need to have at least Excel 2003 to create the report. I have Office 2013 installed on my PC. Why can't I generate the Resource Summary - Visual Report?
    Thursday, December 11, 2014 4:23 PM

Answers

  • Indeed Tom, I was considering the other way around (Project 2013 with Excel 2010). But apparently Excel 2013 should work by now with Project 2010.

    Please refer to this thread which proposes to

    • find where the Winproj.exe file is located for Project 2010,
    • where the Excel.exe file is located for Office 2013,
    • and then to copy the Excel.exe to the same folder as the Winproj.exe folder

    To repair Excel, go to the control panel, select Office row and click on "repair" or "modify".


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Marked as answer by Tom_Herrington Friday, December 12, 2014 12:31 PM
    Thursday, December 11, 2014 6:13 PM
    Moderator

All replies

  • Hi Tom,

    This message is often related to where the EXCEL.EXE file is located. Find it, make a copy of it and copy it to the Program Files/Microsoft Office/Office15 folder. (Reference here)

    Another way to solve it is described by Dale in this thread.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Thursday, December 11, 2014 4:35 PM
    Moderator
  • Guillaume,

    Thanks for responding so quickly to my query.  However, I have Excel in the Office 15 folder now.  Dale Howard mentions a "repair" of Excel 2013 to make it work.  How do I do this?  Secondly, a general Bing search turned up a comment from Microsoft stating that Visual reports in PS 2010 will only work with Office 2010 (see link to article below).  A workaround would be great.  

    https://support.microsoft.com/kb/2863707?wa=wsignin1.0

    Thursday, December 11, 2014 5:58 PM
  • Indeed Tom, I was considering the other way around (Project 2013 with Excel 2010). But apparently Excel 2013 should work by now with Project 2010.

    Please refer to this thread which proposes to

    • find where the Winproj.exe file is located for Project 2010,
    • where the Excel.exe file is located for Office 2013,
    • and then to copy the Excel.exe to the same folder as the Winproj.exe folder

    To repair Excel, go to the control panel, select Office row and click on "repair" or "modify".


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Marked as answer by Tom_Herrington Friday, December 12, 2014 12:31 PM
    Thursday, December 11, 2014 6:13 PM
    Moderator
  • Guillaume,

    I copied Excel and Visio 2013 from Office15 to Office14 where WINPROJ was located and it works!!  Thank you for the workaround procedure.

    Friday, December 12, 2014 12:30 PM
  • You're more than welcome Tom!

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, December 12, 2014 12:57 PM
    Moderator