How to fix KB00804 – VBA Errors in Microsoft Excel?

excel

Issue:

This KB combines and replaces the information that was found in these other KBs:

  • KB00364 – PI add-ins to Excel not available with various VBA errors after upgrading to Office 2010.
  • KB00267 – Run-time error ‘459’: Object or class does not support the set of events” or “Compile Error in Hidden module: Main” error message appears when opening Excel installed with PI Data Link.
  • KB00526 PI Data Link error: Object library invalid or contains references to object definitions that could not be found.
  • KB00631 PI Data Link Error: “System Error &H80040111 (-2147221231). Class Factory cannot supply requested class.

Read more