Difference between revisions of "Adding a Trusted Location in Microsoft Excel"

no edit summary
Line 5: Line 5:
On some machines, ExcelReportLink opens but doesn't start. On others, ExcelReportLink opens but shows a compile error. Adding a trusted location in Microsoft Excel normally resolves these two problems.
On some machines, ExcelReportLink opens but doesn't start. On others, ExcelReportLink opens but shows a compile error. Adding a trusted location in Microsoft Excel normally resolves these two problems.


== Adding a Trusted Location in Microsoft Excel 2007 ==
#'''[[Adding a Trusted Location in Microsoft Excel 2007]]''';


[[File:AddTrustedLocationExcel2007.png|300px|thumb|right|Adding a trusted location in Microsoft Excel 2007]]
#'''[[Adding a Trusted Location in Microsoft Excel 2010 or 2013]]''';


# Start '''Microsoft Excel''';
# Click on the '''Round Office''' button;
# Click on the '''Excel Options''' button;
# Click on the '''Trust Center''' entry in the list on the Excel Options dialogue;
# Click on the '''Trust Center Settings...''' button;
# Click on the '''Trusted Locations''' entry in the list on the Trust Center dialogue;
# If ExcelReportLink is installed on a network, tick the '''Allow Trusted Locations on my network''' option;
# Click on the '''Add new location...''' button;
# Click the '''Browse...''' button and select the folder where ExcelReportLink is installed'
# Tick the '''Subfolders of this location are also trusted''' checkbox;
# Click OK to add the trusted location;
# Click on the '''OK''' button of the Trust Center dialogue;
# Click on the '''OK''' button of the Excel Options dialogue;
# Close '''Microsoft Excel''';
Once the Trusted Location has been added you should be able to start ExcelReportLink.  However, we do recommend you ensure no disabled items have been added. See [[Compile error due to disabled items]] for more information
== Adding a Trusted Location in Microsoft Excel 2010 or 2013 ==
[[File:AddTrustedLocationExcel2013.png|300px|thumb|right|Adding a trusted location in Microsoft Excel 2010 or 2013]]
# Start '''Microsoft Excel''';
# Click on the '''File''' button;
# Click on the '''Options''' entry in the list;
# Click on the '''Trust Center''' entry in the list on the Excel Options dialogue;
# Click on the '''Trust Center Settings...''' button;
# Click on the '''Trusted Locations''' entry in the list on the Trust Center dialogue;
# If ExcelReportLink is installed on a network, tick the '''Allow Trusted Locations on my network''' option;
# Click on the '''Add new location...''' button;
# Click the '''Browse...''' button and select the folder where ExcelReportLink is installed'
# Tick the '''Subfolders of this location are also trusted''' checkbox;
# Click OK to add the trusted location;
# Click on the '''OK''' button of the Trust Center dialogue;
# Click on the '''OK''' button of the Excel Options dialogue;
# Close '''Microsoft Excel''';
Once the Trusted Location has been added you should be able to start ExcelReportLink.  However, we do recommend you ensure no disabled items have been added. See [[Compile error due to disabled items]] for more information.


== Related Topics ==
== Related Topics ==


* [[Troubleshooting Start-Up Problems]]
* [[Troubleshooting Start-Up Problems]]