XLS LibraryXLS Library
Excel Tips & Shortcuts

FactSet Excel Add-In Not Working? A Complete Troubleshooting Guide

Urgent troubleshooting guide for when the FactSet Excel Add-In isn't functioning. Step-by-step checks, fixes, and prevention tips to restore connectivity with Excel and safeguard your workflow.

XLS Library
XLS Library Team
·5 min read
Excel for WindowsExcel TipsVBAExcel Tutorials
FactSet Add-In Troubleshoot - XLS Library
Photo by RDNE Stock projectvia Pexels
Quick AnswerSteps

Most often the FactSet Excel Add-In isn’t working due to an out-of-date plugin, a misaligned Office build, disabled or blocked add-ins, or a corrupt Office profile. Begin with a quick reset: update FactSet and Office, enable the COM Add-In, and run a repair of Microsoft 365. If this doesn’t fix it, proceed with the full steps below.

Understanding the problem: factset excel add in not working

When the FactSet Excel Add-In isn’t functioning, you’ll often see errors like the add-in not loading, ribbon buttons appearing dimmed, or data not syncing from FactSet. This guide tackles the issue quickly and methodically so you can resume your analysis with minimal downtime. In this context, the exact phrase factset excel add in not working is the user’s reported symptom, and diagnosing it relies on checking installation status, software compatibility, and network conditions. The XLS Library team emphasizes a structured approach to bring you back to productive work fast. By following these steps, you’ll address both the symptom and the underlying causes, reducing the chance of recurrence and ensuring smoother Excel workflows.

Common causes behind the issue (factset excel add in not working)

There are several frequent culprits that cause this problem. An out-of-date FactSet add-in or Office build is the top offender, followed by add-ins being disabled or blocked by security policies, a corrupted Office profile, or conflicting Excel add-ins. In corporate environments, IT policies can restrict COM add-ins, which blocks the FactSet integration. Finally, installation errors or incomplete updates can leave the add-in in a partially loaded state. Understanding these causes helps you target fixes quickly.

Quick checks you can try right now

Start with the simplest steps first to confirm basic health. Check that the FactSet Add-In appears in Excel’s COM Add-Ins and that it’s enabled. Verify your Office and FactSet versions are up to date, then run a repair of Office if available. If the add-in still won’t load, try launching Excel in Safe Mode to rule out conflicting add-ins, and review Windows firewall or antivirus settings that might block the add-in. Finally, sign out and back into FactSet if credentials are required for data access.

How to verify installation and activation

To verify installation, open Excel, go to File > Options > Add-Ins, and inspect the list of Active COM Add-Ins. If FactSet isn’t listed, run the installer again or contact IT to ensure the component is allowed by policy. Check the Office version compatibility with the add-in's requirements and confirm you’re using the correct 32-bit vs 64-bit Office installation. If the add-in appears but behaves oddly, consider repairing Office or reinstalling the FactSet component.

Environment, versions, and compatibility considerations

Environment matters. Ensure your Windows version supports the Office build you’re using, and that you’re not running a legacy Office version with a modern add-in. Corporate proxies, VPNs, or restricted networks can also interfere with add-in activation and data retrieval. If you rely on multiple Excel workbooks, verify that the add-in is enabled across all profiles and that user permissions allow COM add-ins to load. Remember: compatibility isn’t just about software, but about settings and network policies too.

From basic checks to a full repair: a practical path

If basic checks fail, proceed with a structured repair path. Start with updating both FactSet and Office, re-enabling the add-in, and running Office’s built-in repair. If issues persist, uninstall and reinstall the add-in, then perform a full Office repair and confirm the FactSet installation is complete. In many cases, reinstallation and a clean profile resolve stubborn integration problems.

When to escalate to support and prevention tips

If the issue remains after following the steps, reach out to your IT department or FactSet support with logs and error messages. Document the Office build, FactSet version, and any recent updates or policy changes. To prevent future problems, keep the add-in and Office up to date, avoid multiple conflicting add-ins, and schedule periodic checks of add-in health as part of your maintenance routine.

Steps

Estimated time: 25-40 minutes

  1. 1

    Check prerequisites and licenses

    Confirm you have an active FactSet license and that your Excel workspace is accessible. Verify the add-in shows in Excel as installed and that your user account has permission to load COM Add-Ins.

    Tip: Document your current Office version and FactSet build before making changes.
  2. 2

    Update FactSet and Office

    Run the FactSet updater and apply any available Office updates. A mismatch between add-in and Office versions is a common cause of failure.

    Tip: Restart Excel after updates to ensure changes take effect.
  3. 3

    Enable the add-in in Excel

    Open Excel, go to File > Options > Add-Ins > Manage: COM Add-ins, and ensure FactSet Add-In is checked. If it’s listed as disabled, re-enable it and restart Excel.

    Tip: If you see a security prompt, allow the add-in and check trust settings.
  4. 4

    Repair Office and the add-in

    Use Windows Settings to repair Microsoft Office. If available, run the FactSet installer repair to fix missing components.

    Tip: Back up personal templates or add-ins before repairing.
  5. 5

    Reinstall the add-in

    Uninstall FactSet from Control Panel, then reinstall the latest version. Ensure you’re installing the correct 32-bit or 64-bit edition that matches Office.

    Tip: Perform this step on a clean user profile if possible.
  6. 6

    Test and validate

    Open a fresh workbook, try a simple FactSet command, and verify data retrieval. If it works, gradually reintroduce your typical workflows.

    Tip: If problems appear only for certain workbooks, check workbook-level protections or external data settings.

Diagnosis: FactSet Excel Add-In Won't Load or Function

Possible Causes

  • highOutdated FactSet add-in
  • mediumIncompatible Office build or bitness
  • highAdd-In disabled or blocked by security policy
  • lowCorrupt Office profile or installation

Fixes

  • easyUpdate FactSet add-in and Office to the latest versions
  • easyVerify and re-enable the COM Add-In in Excel, check policy blocks
  • mediumRepair Office or perform a clean reinstall of the FactSet component
  • hardReinstall the add-in and test in a new workbook profile
Warning: Avoid running multiple heavy add-ins at once; performance can degrade and trigger load failures.
Pro Tip: Always back up settings before uninstalling or repairing to preserve custom configurations.
Note: If you are in a managed IT environment, some steps may require admin approval.

People Also Ask

Why is the FactSet Excel Add-In not appearing in Excel after installation?

This can happen if the add-in is disabled, blocked by policy, or not installed correctly. Check the COM Add-Ins list in Excel and reinstall if needed. Also ensure you’re using a compatible Office version.

If the add-in doesn’t appear, check Excel's COM Add-Ins list and reinstall if necessary.

Can Office updates cause the add-in to stop working?

Yes. An Office update can create compatibility issues with older add-ins. Always update both Office and the Add-In and verify 32-bit vs 64-bit alignment.

Office updates can affect add-ins, so keep both updated and matching in bitness.

What if the add-in works in Safe Mode but not normally?

Safe Mode bypasses many startup extensions. The issue is likely caused by another add-in or startup script. Disable other add-ins and reintroduce them one by one to isolate the conflict.

If Safe Mode works but normal mode doesn’t, a conflicting add-in is the likely culprit.

Is network policy a common blocker for FactSet add-ins?

Yes, corporate networks or proxies can block data access required by the add-in. Work with IT to ensure necessary endpoints are reachable and blocked ports are opened.

Network policies can block add-ins; coordinate with IT to allow access.

Should I contact FactSet support for issues?

If the issue persists after standard fixes, contact FactSet support with your Office version, add-in version, and any error messages. They can provide troubleshooting tailored to your environment.

Yes—contact FactSet support if problems persist after applying fixes.

Watch Video

The Essentials

  • Always verify updates for both FactSet and Office
  • Enable and test the COM Add-In in Excel
  • Use repair and reinstall when fixes fail
  • Document versions and policies for IT support
Checklist for troubleshooting FactSet Excel Add-In not working
Quick troubleshooting checklist

Related Articles

← More in Excel Tips & Shortcuts