Exporting to Excel Article

Exporting to Excel Article

In addition to the Copy and Paste feature, many screens have an Export to Excel button as per below.



When the button is pressed the following screen will appear:




1) Select the Directory you would like to save the file to;

2) Name the File; and

3) Save.


Once saved the below export monitor should appear on your screen per below:



When the export is complete, the Excel icon per below will highlight:



Click on the Excel icon and your file should open in Excel per the below.  You can also navigate to the location where you saved the file and open from there.




Please note that when your Export data is using a Row Format, the data will exported into Excel in the same format.  To drill into the data use the "+" sign and levels that are shown in the red box.


If you wish to export data with no formatting, set the Row Format per below.



The above "Save as type" sort order is set on App Config/Menu Editor on the Application Configuration tab in General:


    • Related Articles

    • Basic Budget Entry Article

          Tutorial Link   Basic Budget Entry  is used for entering and viewing budgets within two tabs:  Dashboard  Account Details  Other entry and viewing screen options are the  Budgeting Dashboard , and the Custom Budget Entry .  The Dashboard tab ...

    • Custom Budget Entry Article

         Tutorial Link Custom Budget Entry is used for entering and viewing budgets.   As discussed in the Define Custom Budgets Entry Forms, all of the columns can be user defined. Custom Budget Entry has two tabs: Dashboard and Account Details. Other ...

    • Manage Budget Accounts Article

      Standard functionality is Print, Export to Excel, Print to PDF, Auto-fit Columns, Expand/Reduce Column Width, Filter, Column Data Sort - Ascending/Descending, and Copy and Paste. The Right-Click Menu and Short-Cut Keys are: In order to free-up ...

    • Export Budget to GP Article

          Tutorial Link Note: For recovery purposes, Dynamic Budgets maintains an audit trail of all export sessions.  A snapshot of the before state of the records in Great Plains is captured as well as the batch of account records transmitted during the ...

    • Duplicate OrgUnit Assumptions Article

      Duplicate OrgUnit Assumptions is a flexible utility to allow you to duplicate either the line item details of entire Orgunits or certain Objects within Orgunits. The data can be duplicated within the same company and budget or across companies and ...