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:
- Download the Excel file from the portal, e.g. the Personal Budget Template.
- Navigate to the file (likely to be in your Downloads folder).
- Right-click on the Excel file and select Properties.
- In the Properties dialog, select the Unblock checkbox on the General tab.
- Click Apply.
- Send the Excel file to the client attached to an email.
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.
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 ...
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. ...