This site requires JavaScript to be enabled
IE BUMPER

We're currently experiencing some technical difficulties with our Chat channel. To resolve those issues please clear your browser cache and reload the page. Further information: Atricle NEW0000472

Product
Version
Incident
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

"Unable to cast COM object of type Microsoft.Office.Interop.Excel.ApplicationClass’ to interface typ



Situation

You are trying to run a CALC function and receive the following error message:

"Unable to cast COM object of type Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’" This operation failed because the QueryInterface call on the com component for interface with IID '{000208D5-0000-0000-c000-00000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

Solution

This error could be related to some leftover registry entries and can occur after a reinstallation of Microsoft Office.

Navigate to your "Programs & Features" and repair the Office installation. This will repair all references in the registry and the error message should disappear.


Another solution is to ensure that they are on a 64-bit version rather than 32-bit