Following the implementation of Microsoft’s latest global security changes users may experience difficulties in running Microsoft excel tools that utilise macros. This may affect your use of our Capital Gains Tool and Platform Charges calculator.
If, when you download the Capital gains Tool or Platform charges calculator and you see a new ‘security risk’ message appear stating ‘Microsoft has blocked macros from running because the source of this file is untrusted’, please try either of the following options which may help resolve your issue. If neither of these solutions resolve the issue, please speak with your IT colleagues for assistance.
Solution 1:
- Download either the Capital Gains Tool or the Platform charges calculator.
- Click on ‘Enable editing’ in the yellow bar at the top.
- Then click on File – Save As.
- Save to desktop.
- Close the tool or calculator down.
- Re-open the tool or calculator from the file saved to the desktop.
- The macros should then run as required.
Solution 2:
- Download either the Capital Gains Tool or the Platform charges calculator.
- Right click the file itself.
- Select ‘properties’.
- Under ‘general’ – ‘security’, select ‘unblock’.
- Click ‘ok’.
- Open the file.
- The macros should then run as required.