link Excel 2010 - Could not load some object because they are not available in this machine← Back

  1. Open the spreadsheet
  2. Open the developer console with ALT-F11
  3. Open Tools -> References
  4. Note the names and file locations of any controls that are marked MISSING
  5. Search a known working PC or the Internet for those controls (usually ending in .OCX)
  6. Copy the controls to the location noted earlier
  7. Register each new control on the new PC e.g.
    regsvr32 C:\Path\To\Control.OCX
    You should get a message that the control was successfully registered.
  8. Open the spreadsheet again and it should now be functional


There are no comments

Post a comment