Microsoft Excel Add Ons For Mac

  1. You can put add-ins anywhere in Finder. If you want to make an add-in available to all Mac OS X user accounts on a computer, put them into Applications:Microsoft Office 14:Office:Add-Ins. The Documents folder is a good place to put add-ins to be used by a particular OS X user account.
  2. Add-ins are coming to Microsoft Office for Mac Office for Mac's forthcoming add-in support is one of a number of new add-in features coming to Microsoft's productivity suite.
  3. StatPlus:mac LE is not a VBA add-in for Excel, but it does provide features comparable to Analysis ToolPak. Mike Middleton, www.TreePlan.com, www.MikeMiddleton.com Did this solve your problem?
  4. Excel Add-ins documentation. With Excel add-ins, you can use familiar web technologies such as HTML, CSS, and JavaScript to build a solution that can run in Excel across multiple platforms, including on Windows, Mac, iPad, and in a web browser.
-->

Apr 05, 2018  How to Install Office Add-ins for Mac and Windows Unfortunately, installing an add-in on an Office Online app doesn’t automatically add it to your desktop version of the program. You'll need to do that separately. In Word, Excel, and PowerPoint, open an existing or new document, click the “Insert” tab, and select the “My Add-ins” button. Click the File tab, click Options, and then click the Add-Ins category. If you're using Excel 2007, click the Microsoft Office Button, and then click Excel Options. In the Manage box, select Excel Add-ins and then click Go. If you're using Excel for Mac, in the file menu go to Tools Excel Add-ins. Unlike COM add-ins, Office Add-ins don't involve code that runs on the user's device or in the Office client. For an Office Add-in, the host application, for example Excel, reads the add-in manifest and hooks up the add-in’s custom ribbon buttons and menu commands in the UI.

Mac

Because add-ins are developed using HTML and JavaScript, they are designed to work across platforms, but there might be subtle differences in how different browsers render the HTML. This article describes how to debug add-ins running on a Mac.

Debugging with Safari Web Inspector on a Mac

If you have add-in that shows UI in a task pane or in a content add-in, you can debug an Office Add-in using Safari Web Inspector.

To be able to debug Office Add-ins on Mac, you must have Mac OS High Sierra AND Mac Office Version: 16.9.1 (Build 18012504) or later. If you don't have an Office Mac build, you can get one by joining the Office 365 Developer Program.

To start, open a terminal and set the OfficeWebAddinDeveloperExtras property for the relevant Office application as follows:

  • defaults write com.microsoft.Word OfficeWebAddinDeveloperExtras -bool true

  • defaults write com.microsoft.Excel OfficeWebAddinDeveloperExtras -bool true

  • defaults write com.microsoft.Powerpoint OfficeWebAddinDeveloperExtras -bool true

  • defaults write com.microsoft.Outlook OfficeWebAddinDeveloperExtras -bool true

Then, open the Office application and sideload your add-in. Right-click the add-in and you should see an Inspect Element option in the context menu. Select that option and it will pop the Inspector, where you can set breakpoints and debug your add-in.

Note

If you're trying to use the inspector and the dialog flickers, update Office to the latest version. If that doesn't resolve the flickering, try the following workaround:

  1. Reduce the size of the dialog.
  2. Choose Inspect Element, which opens in a new window.
  3. Resize the dialog to its original size.
  4. Use the inspector as required.

Clearing the Office application's cache on a Mac

Add-ins are often cached in Office for Mac, for performance reasons. Normally, the cache is cleared by reloading the add-in. If more than one add-in exists in the same document, the process of automatically clearing the cache on reload might not be reliable.

You can clear the cache by using the personality menu of any task pane add-in.

  • Choose the personality menu. Then choose Clear Web Cache.

    Note

    You must run macOS version 10.13.6 or later to see the personality menu.

You can also clear the cache manually by deleting the contents of the ~/Library/Containers/com.Microsoft.OsfWebHost/Data/ folder.

Note

If that folder doesn't exist, check for the following folders and if found, delete the contents of the folder:

  • ~/Library/Containers/com.microsoft.{host}/Data/Library/Caches/ where {host} is the Office host (e.g., Excel)
  • ~/Library/Containers/com.microsoft.{host}/Data/Library/Application Support/Microsoft/Office/16.0/Wef/ where {host} is the Office host (e.g., Excel)
  • com.microsoft.Office365ServiceV2/Data/Caches/com.microsoft.Office365ServiceV2/

An add-in enhances or works with Office 2011 for Mac software in some way. Add-ins are sometimes called plug-ins or add-ons. Here are three examples of excellent commercial-quality add-ins that work with Mac Office:

  • EndNote (www.endnote.com): A high-end bibliography product for Microsoft Word.

  • MathType (www.dessci.com/en/products/MathType_Mac): The full version of Equation Editor that’s included in Office. It lets you put mathematical symbols in Word, Excel, and PowerPoint.

  • TurningPoint (www.turningtechnologies.com): Use clickers to capture audience responses in real time and present the results on PowerPoint slides. This software is used in classrooms, quiz shows, marketing studies, and more.

Many add-ins made for Office for Windows can work on your Mac, so be sure to check their system requirements. Almost all add-ins can be made Mac-compatible with a little effort, but you may have to request the developer of a nonfunctioning add-in to make that extra effort.

You can put add-ins anywhere in Finder. If you want to make an add-in available to all Mac OS X user accounts on a computer, put them into Applications:Microsoft Office 14:Office:Add-Ins. The Documents folder is a good place to put add-ins to be used by a particular OS X user account.

A few commercially produced add-ins are installed using the Mac OS X installer program. Because making an installer is an art of its own and takes extra time and effort on the add-in developer’s part, you install most add-ins manually using the Add-Ins dialog in Office.

A Word add-in is a template file that contains VBA (Visual Basic Editor) code. You can add such a template to the Templates and Add-Ins dialog. In PowerPoint and Excel, an add-in has a special file extension and is not necessarily a template.

Add-In Extensions
ApplicationNew Add-In File ExtensionOld Add-In File Extension
Word.dotm.dot
Excel.xlam.xla
Excel macro enabled template.xltm.xlt
PowerPoint.ppam.ppa
PowerPoint macro enabled template.potm.pot

To open the Add-Ins dialog, here’s what you do:

Excel Add-ins For Mac

  • Word: Choose Tools→Templates and Add-Ins.

  • Excel and PowerPoint: Choose Tools→Add-Ins.

  • Word, Excel, and PowerPoint: Click the Developer tab on the Ribbon and then click Add-Ins→Add-Ins.

When you have the Add-Ins dialog open, you can do the following simple tasks to add, remove, load, and unload add-ins:

Browsing your passwords is simplest if you click the “Passwords” category, then sort by “Kind.”You can also search if there’s a specific thing you’re looking for, but remember to check multiple keychains if you don’t find what you want right away. Key a password from mac keychain for a microsoft products. Browsing Passwords on Your MacRELATED:Most users opening Keychain Access are looking for a specific password they saved earlier, such as a or a password used by a specific website.

  • Load: Same as selecting the check box next to the add-in’s name. Loading also runs the add-in. (Available only in Excel and PowerPoint.)

  • Unload: Same as deselecting an add-in’s check box. Unloading disables the add-in. (Available only in Excel and PowerPoint.)

  • Add: Click to open the Choose a File browser, where you can browse to an add-in template in Finder and add your add-in to the list.

  • Remove: Click to remove the selected add-in from the list.

Microsoft Excel Add Ins For Mac

In Word, when you select an add-in’s check box or click the Add button, you load the template, thereby making the VBA routines that it has available globally within all open documents in Word. A loaded template is called a global template. Revisit the Templates and Add-Ins dialog to re-load your template(s). To disable an add-in, deselect its check box or click the Remove button.

Excel and PowerPoint add-ins are also loaded and unloaded using check boxes. When you close Excel or PowerPoint, add-ins that were loaded at closing reload themselves when you reopen the application.