Making Excel Work for You in Dynamics GP v.10
Dynamics Great Plains v.10 came out with a brand new reporting tool called Excel Refreshable Reports. The new refresh feature in these Excel Reports uses what is known as a data connection to fetch a specific set of data from Microsoft SQL Server. With a click of a button, Dynamics GP data is easily accessible from within Excel, giving real-time access to data. The pre-built data connection is configured to refresh Excel data each time the Excel Report is opened.
