Link to home
Start Free TrialLog in
Avatar of support king
support king

asked on

Excel 2016 error could not load some objects because they are not available on this machine

User generated imageHi All, I work in support and a few of my users are having an issue in excel.

When they open an excel 2016 file with what looks like to be a VBA sheet, once they click on a button an error pops up with

Microsoft Form
could not load some objects because they are not available on this machine.

what i know is that it works for some users and not for others.

we are on windows 10 64bit
office 2016 32bit
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

This is usually caused by ActiveX controls, maybe DatePickers. It is because they are not always installed on the computer.

The best way to avoid this is to avoid them. There's a section of free DatePickers here if that's your problem.

Alternative DatePickers for Excel
Avatar of Montoya
Montoya

Hmmm.. you can try going to Control Panel,
Click on Programs and Features
Find Office
click on Office and select change
select add/remove features
click on the top most arrow
click on Run All From my computer

good luck!
Avatar of support king

ASKER

Hi, this is office 365 so there is no option to run all from my computer

@roy is there any Microsoft package I can install to resolve the issue?
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, Roy, it worked :)
Pleased to help