Excel add-in error Automation error Invalid access to memory location

  • Questions
  • Excel add-in error Automation error Invalid access to memory location
Question ID: 104976

On a new workstation, just installed excel add-in for Quality Center. Running Office 2010, same as on many other newer workstations here that work just fine with the add-in, 32-bit version. Add-in works fine on these other Windows 7 machines. We are able to import test cases without issue.

The new workstation though throws an error when I click on the Export to Quality Center button under the add-ins tab. Error message: "A general error has occurred. Restart Microsoft Excel. ‘Automation error Invalid access to memory location."’

I have tried delete and reinstall, with new version of the add-in available. QC connection is fine, I can test that out on the workstation. I am guessing there must be some setting within excel, but not finding what I need obviously.

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on April 19, 2013 3:57 pm
Answers (2)
Private answer

Sounds like you might have the Enable Data Execution Prevention Mode enabled for your Excel instance on that particular workstation.

Need to have that mode unchecked and thus disabled.

Open your Excel 2010 and navigate to File=>Options=>Trust Center=>Trust Center Settings(button on right side)=>Protected View(on left panel).

Under Protected View, at the bottom of the list in the right side panel you should see Data Execution Prevention and under it Enable Data Execution Prevention Mode. Remove the check from the box to the left and then hit on OK button on the bottom of the window. Click OK on the next window. I would suggest closing Excel and reopening and then checking if you can do the Export to Quality Center without the error message pop up.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on April 19, 2013 3:59 pm
It was enabled. Unchecking the option and reopening excel, export to quality center gave me the popup to connect to QC. No more error. Thank you.
( at April 19, 2013 4:06 pm)
Private answer

Awesome... working thanks a lot... I faced this iseue for quite long

Thanks, Amruta

Marked as spam
Posted by (Questions: 0, Answers: 1)
Answered on March 25, 2015 1:35 pm