Microsoft Excel Add Ons For Mac
- 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.
- 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.
- 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?
- 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.
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:
- Reduce the size of the dialog.
- Choose Inspect Element, which opens in a new window.
- Resize the dialog to its original size.
- 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.
Application | New Add-In File Extension | Old 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.