Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Export from MS Project 2003 to Excel 2007

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-04-2010
Member
 
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.

Reply With Quote
  #2  
Old 07-04-2010
Member
 
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.
Reply With Quote
  #3  
Old 07-04-2010
Member
 
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.
Reply With Quote
  #4  
Old 08-04-2010
Member
 
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.
Reply With Quote
  #5  
Old 08-04-2010
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 03:26 PM.