Microsoft has blocked macros in Excel file

Microsoft has blocked macros in Excel file

Microsoft has changed the default behaviour of Office applications to block macros in files downloaded from the internet or opened from an email attachment. This means that when you download an Excel file from the portal that contains macros, a red banner will appear in the Excel toolbar with a security risk warning and the macros will not run. Clicking the Learn More button takes you to an article containing information about how to enable the macros.

To fix this issue:
  1. Download the Excel file from the portal, e.g. the Personal Budget Template.
  2. Navigate to the file (likely to be in your Downloads folder).
  3. Right-click on the Excel file and select Properties.
  4. In the Properties dialog, select the Unblock checkbox on the General tab.
  5. Click Apply.
  6. Send the Excel file to the client attached to an email.

Important info
There are instructions for the client to enable the macros on the Instructions page of the Personal Budget Template file in case they experience the same error when saving the Personal Budget Template from an email attachment.

    • Related Articles

    • Importing clients via CSV file

      The CSV import is a feature available in the Manage Clients area for administrators, and in the Clients area firm-wide. It allows users to add clients and their contacts to The Gap Portal via a CSV file. Using our CSV template To start, navigate ...
    • The Gap Seminars bridge

      The Gap Seminars bridge contains everything you need to market and deliver educational seminars to clients and prospective clients. Each seminar is designed to educate attendees while positioning ways that you can better support attendees. Important ...
    • Platform security

      The portal has the following security features: Data Encryption AWS Data Location A Disaster Recovery Plan A Data Retention System Multi-Factor Authentication AWS Web Application Firewall for Network Security Password Security Penetration Testing The ...
    • Managing custom templates

      The Templates tab is where you can utilise default templates to create your own bespoke content and systems in the portal. To start, navigate to Main menu >  > Templates. Documents in this tab are used to create templates for bespoke services Use the ...
    • Filing documents to FYI

      The Gap Portal integrates with FYI so you can easily file your portal emails, attachments and documents. How to set up the FYI integration Attention You must have administrator rights in The Gap and in FYI to follow the setup steps in this article. ...