For tools that are Excel addins, MS Excel is required.
MS Works is not Excel and does not support add-ins.
Most of our tools are Excel Add-ins. The tools are supported under various versions of Excel, from Excel 2000 – 2013 for Windows. Several are also supported when using Excel 2011 on the Mac.
Not all addins will work when using all of these Excel versions. Some require features only available in newer Excel versions. Each of the tools’ home pages indicates the supported versions of Excel.
Some relatively unusual settings can impact loading add-ins, as they disable the ability to run them:
Excel 2003: Choose Tools | Macro | Security | Trusted Publishers and then make sure the two available check-boxes are checked.
Excel 2007: To see this setting, go to Excel Options from the Office button in the upper-left corner of Excel, then Trust Center, Trust Center Settings, Add-ins, then make sure all three of the options there are unchecked. Pick both Com addins and Excel addins from the pick list at the bottom of the windows, and then make sure none are loaded Except BRC Addins. Then restart Excel.
Excel 2010: Use steps similar to Excel 2007 to find the Trust Center Settings.
Excel 2013: Use steps similar to Excel 2007 to find the Trust Center Settings.
Excel 2011 Mac: Use steps similar to Excel 2003.
The message reads, “This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.“
This happens when VBA for applications is not installed with Office. It is installed by default in most cases. To resolve the situation, reinstall Office or Excel and install the Visual Basic for Application components.
Excel 2011 on the Mac is known to not install VBA by default.
Why do I get a prompt for a “BRConsulting” password when closing Excel or taking some other action in Excel?
This is an Excel bug that happens to some Excel uses at different points. It is no longer very common and is generally caused by virus checker’s that try to decompile the addin. This triggers Excel to put up a password prompt. The fix is to teach your virus checker to stop checking Excel addins for viruses in this way or to get a different virus checker that behaves properly as it interacts with Excel.