After a critical Microsoft update the Ava report module fails to launch Excel and gives "excel has been manually controlled" error.
This occurs when the (security) update removes Excel registration from the automation process
You can easily check if this has occurred (once you know how).
Check that Excel is actually installed on this PC. (Just in case its a new machine!)
You may be tempted to roll back the update...just say no. This solution does not use registry hacks.
Open the start menu and enter by clicking on the windows start button. Type in "dcomcnfg" in the search box immediately above the Windows start button, as illustrated below:
If it is not listed there, then this is the problem.
There is a technet article on the issue. The link is at the end of this article. It contains a typo in the command syntax and will not run correctly if followed literally.
So the correct instructions are here:
Open the start menu and enter by clicking on the windows start button. Type in "cmd" in the search box immediately above the Windows start button, as illustrated below:
Right mouse click on the "cmd" entry and left mouse click on "run as Administrator"
You will now get the following window
Change the current folder (aka Directory) to the location of Excel.exe. In a 64 bit system with Office 2010 installed this will be:
C:\Program Files (x86)\Microsoft Office\Office14
So you need to type:
CD C:\Program Files (x86)\Microsoft Office\Office14
Just in case you didnt know, there is an easy way to do this:
Copy the line above to the clipboard (highlight it and press <crtl + c>
Now right mouse click on the window title bar, you will get a drop down menu as below. Navigate to paste and click
The clipboard text will be entered so:
Hit the enter key to run
Now type the following
(or highlight it here and paste to the window)
Hit the enter key to run.
Now try to run a report. If all is ok you have solved the problem. If not, then follow the rest of the MS support article here: