none
Project Server 2010 export to Excel 2007 fails RRS feed

  • Question

  • I keep getting the following error when I try to export Resource Availability to Excel.  I am using Project Server 2010, Excel 2007, IE8, Windows 7.  I have PS set as a intranet site with low security set.  Coworkers with the same setup are not having this issue.  I have tried exporting to Excel with Excel open, Excel closed, on a hardwire network connection, on wireless network connection, on my corporate VPN and not on my corporate VPN. 

    Microsoft Office Excel cannot access the file "URL here" for the possible reasons:

    -The file name or path does not exist.

    -The file is being used by another program

    -The workbook you are trying to save has the same name as a currently open worklbook.

    Please provide suggestions on what to try differently to make the export work.  I have tried downloaded other version of IE and have the same issue.

    Tuesday, June 3, 2014 3:41 PM

All replies

  • Hi Julia,

    since nobody jumped in, I'll give a try!

    Have you tried to reinstall Excel or at least repair it?


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Friday, June 6, 2014 6:04 PM
    Moderator
  • Try different things with your browser such as compatilbity mode.

    Use a 32 bit IE browser. Excel 2007 was  32 bit and didn't work well with  64-bit browser.  Try finding an OS with older version of IE.  

    I also found that it may fail but the data is in a buffer.  Open up Excel and try doing a Cntrl-V and see if the results will paste into excel.

    Cheers  


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Thursday, June 12, 2014 2:48 AM
    Moderator