How to use the add-in in Excel

by

With an Excel add-in, you can increase the functionality of the Excel application on a variety of platforms, such as Windows, Mac, iPad, and web browsers. Utilize Excel add-ins inside of a workbook to:

  • Read and write Excel data
  • Interact with Excel objects

Use a web-based task pane or content pane to expand functionality. Include contextual menu items or unique ribbon buttons. Include bespoke features. Enhance user interaction by utilizing a dialog window.

The framework and Office.js JavaScript APIs needed to create and use Excel add-ins are provided by the Office Add-ins platform. The following advantages come with building your Excel add-in with the Office Add-ins platform:

  • SUPPORT ACROSS-PLATFORMS: Excel add-ins are compatible with Office on Windows, Mac, iPad, and the web.
  • CENTRALIZED DEPLOYMENT: Administrators can quickly and simply make Excel add-ins available to users across the entire company.

Add-in Excel Formula

Let’s investigate the add-in Excel formula.

Values are added by the SUM function. Individual values, cell references, ranges, or a combination of all three can be added. For instance:

  • Values in cells A2:10 are added using =SUM(A2:A10).
  • A2:A10, C2:C10) = SUM adds the numbers in cells C2:C10 and A2:10 together.
  • Total ([NUMBER1], [NUMBER2],…)

Updating Add-Ins in Excel

Let’s get started on updating Add-Ins in Excel.

  1. Click INSERT > MY ADD-INS in Word 2016, Excel 2016, or PowerPoint 2016.
  2. Click PROJECT > MY ADD-INS in Project 2016.
  3. Next, in order to update the list in the Office Add-ins dialog, click Refresh.
  4. Refresh the list to view all of your apps if one isn’t visible in the Office apps list.
  5. Click INSERT > MY APPS in Word 2013, Excel 2013, or PowerPoint 2013.
  6. Click PROJECT > APPS FOR OFFICE in Project 2013.
  7. To view your list of apps under APPS FOR OFFICE, select MY APPS. To update the list, select REFRESH.

Enabling Add-Ins in the Excel Registry

Now let’s get started on how to enable add-ins in the Excel registry.

METHOD 3: ACCESS THE DATABASE

You can use the registry to load an add-in automatically for every workbook. As follows:

  1. Use Windows Key + R to open the Registry Editor, then type "regedit" and hit Enter.
  2. To access the Options, go to HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0Excel. (Note: Depending on your Excel version, the "16.0" might differ).
  3. In the pane on the right, right-click and choose New > String Value.
  4. "OPEN" is the new string value’s name (no quotes needed).
  5. Enter the complete path to the add-in file, including the file name and extension (e.g., C:MyAddIn.xlam), by double-clicking the "OPEN" string value.