Fix the “Object variables not set” error by checking if there are any conflicts between add-ins and Office. Go to “System Registry” and erase outdated references from it. You can also repair Excel to fix the error.