Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Manage Excel Services Trusted File. As for my test if I select Disable all macros except digitally signed macros I can run macros in it even the file is not in trust location. As per my test on my side marco can run XLSM and xltm files in trust location.
If you change the trust location settings please make sure you have restarted Excel. In a data refresh operation the Analysis Services instance not the PowerPivot System Service requests the data from external data sources. Click File Options.
Press CtrlO to get to the File Open screen and choose Options from the left menu. Easily Hide the Quick Launch in SharePoint 2013. On the Manage Excel Services Application page click Trusted File Locations. Select the location to be removed and then click Remove and then click OK.