Adding a Trusted Location in Microsoft Excel 2016 and later

From BudgetLink Wiki
Jump to navigation Jump to search

Overview

BudgetLink has workbooks that require installing Ribbons and enabling Macros to work.

On the first run, you will be prompted to add a Trusted Location automatically. By adding a Trusted Location, you ensure that Excel identifies the files as Safe.

Select Yes to enable the files required by BudgetLink to run after they are added to Trusted Location.

BudgetLink installed on a Local System

Excel Options - Trust Center
Trust Center Settings - Trusted Locations
%APPDATA% folder
Adding a Trusted Location in Microsoft Excel 2016 and later
Adding a Network Drive to Trusted Location
  1. Start Microsoft Excel.
  2. Click on File > Options.
  3. Click on Trust Center tab on the left side panel.
  4. Click on the Trust Center Settings... button.
  5. A new Trust Center dialog box will open up.
  6. Click on the Trusted Locations entry in the list on the Trust Center dialog box.
  7. In another file explorer window, enter "%APPDATA%" in the address bar without quotes
  8. An "Appdata Roaming" folder will be opened.
  9. Search and browse to BudgetLink folder. Copy the path to this folder.
  10. Navigate back to Trust Center Dialog box and click Add New Location button.
  11. Paste the copied text in the Path input box and select the Subfolders of this location are also trusted checkbox.
  12. Click on the OK button of the Trust Center dialogue.
  13. Click on the OK button of the Excel Options dialogue.
  14. Close Microsoft Excel.

BudgetLink installed in Shared Location

If BudgetLink is installed on a Network Location or Mapped Drive, the BudgetLink Ribbon will be stored in Local %APPDATA% folder which needs to be manually added to Trusted Location.

  1. Start Microsoft Excel.
  2. Click on File > Options.
  3. Click on Trust Center tab on the left side panel.
  4. Click on the Trust Center Settings... button.
  5. A new Trust Center dialog box will open up.
  6. Click on the Trusted Locations entry in the list on the Trust Center dialog box.
  7. In another file explorer window, enter "%APPDATA%" in the address bar without quotes
  8. An "Appdata Roaming" folder will be opened.
  9. Search and browse to BudgetLink folder. Copy the path to this folder.
  10. Navigate back to Trust Center Dialog box and click Add New Location button.
  11. Paste the copied text in the Path input box and select the Subfolders of this location are also trusted checkbox.
  12. Mark the Allow Trusted Locations on my network checkbox.
  13. Click on the Add new location... button.
  14. Click the Browse... button and select the folder where BudgetLink is installed.
  15. Select the Subfolders of this location are also trusted checkbox.
  16. Click OK to add the trusted location.
  17. Click on the OK button of the Trust Center dialogue.
  18. Click on the OK button of the Excel Options dialogue.
  19. Close Microsoft Excel.

Once the Trusted Location has been added you should be able to start BudgetLink. However, we do recommend you ensure no disabled items have been added. See Compile error due to disabled items for more information.


BudgetLink still doesn't work

If BudgetLink still doesn't start, please re-install BudgetLink

  1. Navigate to this link to download BudgetLink Installer
  2. To eliminate external issues, install Budgetlink from scratch on the Local C:\ Drive.
  3. If your current version is installed in C:\ Drive, rename the folder before installing to avoid conflict with the new installation.
  4. After installation, Allow Trusted Location to be automatically added.
  5. Enable and Install BudgetLink Ribbon


Related Topics

Troubleshooting Start-Up Problems
Enabling Macros in Microsoft Excel
Troubleshooting Publish Problems