# READ THIS RIGHT NOW: Smartlist: Exports slowly to Excel – Part 1

- URL: https://dynamicaccounting.net/read-this-right-now-smartlist-exports-slowly-to-excel-part-1/
- Date: 2010-05-14
- Topics: Reporting & BI, Excel & Office
- Dynamics GP versions mentioned: GP 2010, GP 10
- Type: link to an external article
- Source: https://blogs.msdn.microsoft.com/developingfordynamicsgp/

I don’t yell often so stop what you are doing and go to [Developing for Dynamics GP](https://blogs.msdn.microsoft.com/developingfordynamicsgp/) to read Patrick Roth’s article on how to dramatically speed up SmartList exports to Excel for GP 10 and GP 2010. The post is: [Smartlist: Exports slowly to Excel – Part 1](https://blogs.msdn.microsoft.com/developingfordynamicsgp/2010/05/13/smartlist-exports-slowly-to-excel-part-1/)  
Patrick details a Dex.ini switch for GP 10 and GP 2010 that significantly speeds up SmartList exports to Excel. On a run of the mill laptop running GP 2010 I loaded a SmartList with 22,229 records. It took 1 minute, 15 seconds to load the window and a mere 27 seconds to send that data to Excel. All of us will be adding this to our list of Dex.ini switches. You should too, right now.