FAQ - Printing reports

Question
Print module fails to run Excel reports
Answer

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:

Start.png

  • Click on dcomcnfg, a window will appear titled component services.
  • Click on the top left most item called console root:
  • Click on Component Services
  • Click the right pointer next to "Computers"
  • Click the right pointer next to "My Computer"
  • Click the right pointer next to "Dcom Config"
  • Drag the vertical btween the first and second panels across to see more of the DCOM config list
  • Scroll down to where "Microsoft Excel Application" should be

Component_Services.png

If it is not listed there, then this is the problem.

The fix:

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"

cmd run as administrator.png

 You will now get the following window

cmd.png

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

copy txt to dos window.png

 The clipboard text will be entered so:

CD Program files Microsoft Office Office 14.png

 Hit the enter key to run

CD Program files Microsoft Office Office 14 post enter.png

 Now type the following

EXCEL.EXE /REGSERVER

(or highlight it here and paste to the window)

CD Program files Microsoft Office Office 14 excel regserver.png

 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:

https://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/11/12/microsoft-excel-does-not-appear-in-dcom-configuration-snap-in.aspx

 

 

If you found this information useful, please share it!


This FAQ was last updated on Wednesday, September 30, 2015

Contact Information

To find out more about Ava solutions you can contact us in a number of ways:
Follow Us...