Results 1 to 6 of 6

Thread: 2010 visual report not working with excel 2010

  1. #1
    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

  2. #2
    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

  3. #3
    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

  4. #4
    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.

  5. #5
    Join Date
    Dec 2007
    Posts
    1,599

    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.

  6. #6
    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

Similar Threads

  1. Office 2010: Excel 2010 stops Responding
    By NProtector in forum Windows Software
    Replies: 7
    Last Post: 08-01-2013, 02:16 AM
  2. Visual C + + 2010 asking for dll file
    By Maximiliano2 in forum Software Development
    Replies: 3
    Last Post: 01-12-2010, 05:27 AM
  3. Replies: 5
    Last Post: 02-02-2010, 02:16 AM
  4. Compare Visual Studio 2010 and Visual Web Developer Express
    By Zacharia in forum Software Development
    Replies: 5
    Last Post: 28-01-2010, 04:27 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,700,794.86051 seconds with 17 queries