ERROR: This workbook cannot be opened because it is not stored in an Excel Services Application trusted location

You might get this error when you try to open an Excel Sheet from your PWA directly. This error is also seen when you try to either open the Reporting sheets present inside the Business Intelligence Center. To fix this issue; you need to open your Internet Explorer browser and add your Project Server URL to the trusted location.