KBA-01833: Microsoft Is Blocking Macros

Problem:

When you open a special Microsoft Excel workbook in Spitfire (BFA, SOV, Period Distribution), you may get the following message:

SECURITY RISK: Microsoft has blocked macros from running because the source of this file is untrusted.

Solution:

First, read KBA-01047, especially the section on Excel Trust, to ensure that your workstation was properly set-up. (See also KBA-01519)

If you are still getting that message, it is because Microsoft has added an additional step in the security process, which requires further set up from you.

You will need to set your site as a trusted site in Windows so macros from the site won’t be checked.

  1. Click the Start button or Windows key and type Internet Options.
  2. Select Internet Options from the search results and the Internet Properties dialog box will appear.
  3. Select the Security tab.
  4. Select Trusted Sites
  5. Click the Sites button.
  6. Type the URL of your site.
    Note: if your URL begins with http:// or network shares, uncheck the Require server verification (https:) for all sites in this zone checkbox.
  7. Click the Add button.
    Important: if your Add button is disabled, contact your IT administrator. (These settings may be controlled by IT policies.)
  8. Click the Close button.
  9. Click the OK button.
  10. Return to Spitfire and try to open your Excel workbook again.

If you still have issues, contact support@spitfiremanagement.com.


KBA-01833; Last updated: September 16, 2022 at 10:04 am