Excel

Many users already know about the facility to export the details of the WinMAGI screen grids directly to Excel. However, did you also know that you can control where that spreadsheet will go to, whether it will automatically load upon creation and whether the spreadsheet will have column totals? Excel 1The User Preferences settings (see User Preferences->Maintenance->WinMAGI properties) allow each user to control where and how the Excel spreadsheet will be created. For example, if you want the numeric columns in the Excel spreadsheet to automatically total, simply tick the ‘Automatic totals on numeric columns’ field on the ‘Grid Export’ tab. When you next export one of the WinMAGI grids to Excel, all of the numeric columns in the grid will have a ‘Total’ cell for all of the numeric columns in the spreadsheet. Try out the other options, such as ‘Automatic Freeze Heading Line’, to see how these options can work for you.

Note that we also recommend that you specify a local ‘Export File Directory’ that specifies a local directory on your PC. This ensures that you do not have update conflicts with other users who may be exporting the same data at the same time.

 

Categories: Uncategorized