SPEED UP EXPORTING SMARTLISTS TO EXCEL
The export process from SmartList to Excel can be made much faster by adding a line to the Dex.ini file. Depending upon the workstation configuration of Dynamics, the Dex.ini file may be on the end users workstation or on Terminal Server. For GP 2013, the Dex.ini file is usually found in this location: C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data. Once the file has been located, right-click on the file and choose "Edit". It should open up in Notepad. Go to the very last line of the file and add the line:
SmartlistEnhancedExcelExport=TRUE
Save the Dex.ini file. Once you re-enter Dynamics and begin exporting SmartList results to Excel, it should be much faster.
|