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



2010 visual report not working with excel 2010

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-03-2011
Member
 
Join Date: Mar 2009
Posts: 10
My MS Project 2010 Visual Report writer is not working with Excel 2010.

I get the error "This Operation requires that you have Excel 2003 or later installed on your computer" I am confused because I do haha, I have 2010.

Is this a known issue or is there a problem on my side?

I am trying to export the dynamic data for a Pivot Table.

I done it recently with MS project 2007 and Excel 2007 but now I am at a new employer.

Please help.

Thanks

Reply With Quote
  #2  
Old 25-03-2011
Member
 
Join Date: Dec 2006
Posts: 489
Re: 2010 visual report not working with excel 2010

Hello skier9er,

Double check your legacy file format settings on the File > Options. Check that "Allow loading...." is selected.

Julie
Reply With Quote
  #3  
Old 27-03-2011
Member
 
Join Date: Mar 2009
Posts: 10
Re: 2010 visual report not working with excel 2010

Thanks Julie,

Is this in Excel or Project? I cant find the " allow loading" setting in either.

Thanks
Reply With Quote
  #4  
Old 27-03-2011
Member
 
Join Date: Mar 2009
Posts: 10
Re: 2010 visual report not working with excel 2010

I just found in project options under security_Legacy Formats_ "Allow Loading files with legacy or non default file formats". And it does not work still comes up with same error- Install 2003 or later.

Thanks.
Reply With Quote
  #5  
Old 27-03-2011
Member
 
Join Date: Dec 2007
Posts: 1,592
Re: 2010 visual report not working with excel 2010

You can try the below fix to solve this issue:
  1. First you need to go into C:\Program Files\Microsoft Office\Office14 and copy the EXCEL.EXE file you find there.
  2. After that simply paste into the following directory: C:\Program Files\Microsoft Office\Office12
  3. Lastly close and reopen Project. Everything seems to work fine on my machine now. Guess it's a bug that'll get caught in an upcoming service pack.
Reply With Quote
  #6  
Old 27-03-2011
Member
 
Join Date: Dec 2006
Posts: 489
Re: 2010 visual report not working with excel 2010

Hi Skier,

I cannot reproduce this on a Windows 7 machine with only Office 2010 and Project 2010 installed.

Do you have a previous version of either Project or Excel installed? The fix that Expertz suggests does seem to work if you have older versions of Project installed.

Julie
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: "2010 visual report not working with excel 2010"
Thread Thread Starter Forum Replies Last Post
Office 2010: Excel 2010 stops Responding NProtector Windows Software 7 08-01-2013 02:16 AM
Visual C + + 2010 asking for dll file Maximiliano2 Software Development 3 01-12-2010 05:27 AM
Techniques for better Report performance in Visual Studio 2010 Marcya Windows Software 5 02-02-2010 02:16 AM
Compare Visual Studio 2010 and Visual Web Developer Express Zacharia Software Development 5 28-01-2010 04:27 AM


All times are GMT +5.5. The time now is 06:53 PM.