How to enable F9 COM Add-In in MS Excel

How to enable F9 COM Add-In in MS Excel

Why does this happen

Sometimes the F9 Com-Add in doesn't load properly or the user mistakenly disables it.

How to enable it

Please follow the below instructions
  • Open Microsoft Excel
  • Open a new Blank workbook
           
  • Click Options

           
  • Click on Add-Ins
  • Select COM Add-Ins from the list
  • Click GO..
          
          
  • Select F9
  • Click OK
          
           

Activating F9

  1. In F9 tab click License.
  2. Click on Activate.
  3. Enter the Activation Code and the click on Activate again.
If you do not have the activation code, login to F9 license  portal here  to get the activation code. F9 can only be activated once per user, so you will need to deactivate it on the portal first before you enter the code in excel.

    • Related Articles

    • Excel prompts for FileBridge Credentials

      Problem When opening an office file (Excel, Word etc.) you get prompted for your FileBridge credentials. This will often happen after a password change. Solution 1 Click on the Windows icon in the taskbar and start typing "Credential Manager" and ...

    • Strikethroughs on PDF after exporting from Excel

      Problem When you using Sage Business Intelligence and using the Excel Add-In, the data content looks correct, and displays properly. However, when the data is exported as a PDF, all the formula cells display as strikethroughs Reason When exported to ...

    • Sage Intelligence Add-in giving error or not showing up in Excel

      Problem: When running Sage Intelligence requiring the Excel add-in, an exception error is shown to the user, or the add-in does not show up in Excel Reason: The likely reason for this problem is that the Excel Add-in is not registered correctly. ...

    • I receive a "Not enough memory" error when exporting to Excel

      Problem: When attempting to export a report from Quickbooks to Excel, you may receive the following error message When clicking ok, you only have the option to export to CSV, like the screenshot below:  Reason: This error usually pops up if the ...

    • QuickBooks reports are slow when exporting to Excel worksheet

      Problem When exporting a QuickBooks report to Excel, the export process is very slow. Resolution While in QuickBooks, perform the following: Open your QuickBooks company file Run a report to export to Excel Select Excel > Create New Worksheet Click ...