I was trying to export to excel a Smartlist Report with about 100K rows and 15 columns but GP is not doing anything. It seems to work with 10K records.
Our excel version is 2010. Our MS Dynamics GP 2013 has version 12.00.1801.
*This post is locked for comments
Hi Emerald,
I was wondering why you couldn't create an Excel report that would pull the data directly out of GP.. ? especially if this is going to be a repeated action, you're going to find it borring to wait for SmartList to export 100k records... not the speediest way of doing it.
The same process directly out of Excel to refresh 100k lines takes less than 30 seconds.. Depending on you GP version, you could use Excel report builder to create one of those refreshable reports.
Never mind, I already found the solution for this issue. I just had to change the limit in the Excel Options.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (