receiving this error message: "Could not load some objects because they are not available on this machine."

Question

Hello,

The following pertains to Excel 2010 (Office 2010 SP 1 is installed and Windows is fully up to date). Running Windows 7, 32bit.

When opening Excel, the following error from Microsoft Forms appears: "Could not load some objects because they are not available on this machine." Originally i thought this error was caused exclusively by two third party add-ons (Dfss Master and SPC XL by SigmaZone). However the same issue occurs when i enable the Solver add-on or the Euro Currency Tools add-on, both of course are native to Excel. If i disable all those add-ons i mentioned, Excel starts up without any errors, however i need these add-ins to work.

Here is a list of things i've tried so far to resolve this:

-Office repair

-Uninstall Office and did a fresh install (Office 2010 is the only version installed). I also reinstalled Office 2010 SP1.

-Went through add/rem features of Office 2010, on the drop down arrow which is before the Microsoft Office and clicked on Run all from my computer, then rebooted.

-Cleared the MS Office cache files at C:\Users[UserName]\AppData\Roaming\Microsoft\Forms" and "C:\Users[UserName]\AppData\Local\Microsoft\Forms"

-Renamed the Excel toolbar file in case its corrupted

-Cleared the XLStart folders:

C:\Users[UserName]\AppData\Roaming\Microsoft\Excel\XLSTART

C:\Program Files\Microsoft Office\Office14\XLStart

-Pressed Alt + F11 to go into the Visual Basic Editor. Went to Tools > References and made sure none of the available references listed said "missing"

-Went through all the settings in Excel's Trust Center and opened up all the security settings so nothing was disabled or blocked

-made sure Microsoft Visual C++ 2010 Redistributable is installed.

If anyone has any other ideas please let me know. I really appreciate anyone who can share any insight on this!

Answer 1

Raju,

Thank you for your suggestions, I tried those steps but it hasn't resolved the issue. If you have any other ideas please let me know, thanks!

Regards,

Answer 2

Hi Baba,

Does the issue occur while opening Excel application or while opening the workbook?

If the issue occurs when you open Excel application then you may manually uninstall and reinstall Excel and check if it works fine.

Make Excel unavailable from Maintenance Mode

Click Start

Control Panel

Program and Features

Choose Microsoft office in the list

Click Change

Add or remove features

Click the drop down arrow for Microsoft Excel and choose ‘Not Available’.

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry,

http://windows.microsoft.com/en-us/windows7/back-up-the-registry

Delete "Excel" key from the following location in registry:

(If some keys can't be deleted or found, please skip them, this will not influence the result of the troubleshooting)

Click on the + sign to expand the registry keys, the keys following the backslash () are sub keys, right click on the last sub key and click Delete.

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\8.0\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\10.0\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\11.0\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Excel

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel

• Close the Registry Editor

Make Excel Available from Maintenance Mode

Click Start

Control Panel

Program and Features

Choose Microsoft office in the list

Click Change

Add or remove features

Click the drop down arrow for Microsoft Outlook and choose ‘Run All from my computer’

Restart the system and check if Excel works fine as expected.

I hope it helps. Let us know if you need further help.

Thank you.