Results 1 to 5 of 5

Thread: Export from MS Project 2003 to Excel 2007

  1. #1
    Join Date
    Oct 2004
    Posts
    39

    Export from MS Project 2003 to Excel 2007

    I am using Windows 7 ultimate with MS Office 2007 and MS Project 2003 installed. I need to export a Project Plan into Excel 2007. To do so, when I select “Save As” option and choose Workbook or Pivot Table, it says “Operation Failed.” So far I have tried several time but still the same result. Am not able to find out the source of the problem. Is it because project is 2003 and Excel is 2007? Is there any compatibility problem or I’m making some mistake?

    Somebody please help.

  2. #2
    Join Date
    Sep 2004
    Posts
    208

    Re: Export from MS Project 2003 to Excel 2007

    Nope, it cannot be version or compatibility problems because I have done it couple of weeks ago with exactly same edition of project and excel. Did you have installed Service Pack 3? If yes then go to Tools > Options > Security tab and make sure you have the bottom option selected to allow creating and loading legacy file formats. Do this and try exporting again. Hopefully you wont be getting that error again.

  3. #3
    Join Date
    Oct 2004
    Posts
    39

    Re: Export from MS Project 2003 to Excel 2007

    Thank you very much for the reply SMichael but I’m still running with Service Pack 2 (no SP3). Is there any such troubleshooting or extra settings I need to configure to get the job done?

    Please help.

  4. #4
    Join Date
    Sep 2004
    Posts
    208

    Re: Export from MS Project 2003 to Excel 2007

    No, there are no such extra settings for SP2, it is only in SP3. But as you are getting the “Operation failed” error I strongly suspect there might be some security problem which is breaking the link or your installation of Project and Office is broken. I will recommend you to put the setup CD again and repair both Office as well as Project.

  5. #5
    Join Date
    Oct 2004
    Posts
    39

    Re: Export from MS Project 2003 to Excel 2007

    That’s it. Finally I managed to fix the problem. Repairing Office and Project didn’t worked. At last I uninstalled Project 2003 and installed MSP 2007 and everything got solved. I think it was the compatibility problem but anyways, your helps appreciated.

Similar Threads

  1. export gantt chart from Project 2007 to Excel
    By hatred in forum Microsoft Project
    Replies: 6
    Last Post: 16-11-2009, 09:37 PM
  2. Exporting from Project 2007 to Word 2003 or Excel 2003
    By Jasper W in forum Microsoft Project
    Replies: 5
    Last Post: 20-04-2009, 11:52 PM
  3. How to export a Project 2003 file into Excel 2003
    By destinyswarrior in forum Windows Software
    Replies: 3
    Last Post: 21-03-2009, 05:45 PM
  4. Export MS Project 2007 to Excel
    By Manik in forum Microsoft Project
    Replies: 4
    Last Post: 13-02-2009, 10:34 PM
  5. Why won't Project Import/Export to/from Excel
    By aghuvi in forum Microsoft Project
    Replies: 2
    Last Post: 19-12-2008, 06:58 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,612,264.93016 seconds with 17 queries