If you want to totally remove the ability of CRM users to “Export to Excel,” you can remove the permission on the Business Management tab of the security role definition. This is good if you don’t want anybody exporting to Excel. But what if you don’t want to remove all Export to Excel, just remove it from […]
Tip #190: IFD and Dynamic Excel Export
If you are facing the login window appearing in the Excel sheet after creating a dynamic Excel export from an IFD-enabled CRM organization, then there’s still a way to get the data into the Excel sheet: Export the Dynamic Worksheets (or Pivot Tables) from Microsoft Dynamics CRM. Open the Dynamic Worksheets with Excel. Excel will […]
Tip #50: Auto-enable content in exported documents
Tired of selecting the Enable Content every time you open an Excel or Word document you’ve exported from CRM, saved from a mail attachment or downloaded? Good news, it is easy to change your settings. Here are the steps: Using Excel as an example: Select File -> Options Select Trust Center Select the Trust Center […]
Tip #48: Update process flow for existing records
So you decided to follow tip 46 and use process flows instead of the sales stage field. How do you update your existing records? If you open a closed opportunity, for example, the record (and the process flow stage) will be non editable. First, understand how the process and stage are stored on the record. if […]
Tip #18: How to disable export from the reports
Sometimes there is a requirement to stop users from being able to export CRM reports. Take away Export to Excel privilege and reports will be displayed without the export button. Dependency on Excel export privilege is, perhaps, a bit unintuitive, and the privilege covers not only Excel but other export formats as well. Privilege is […]