Difference between revisions of "Generating a Report in Excel"
Julia Decker (talk | contribs) |
|||
| Line 35: | Line 35: | ||
| − | [[Category:System Management]][[Category:View It]][[Category:Plug-Ins]] | + | [[Category:System Management]][[Category:View It]][[Category:Plug-Ins for Microsoft Office]] |
Revision as of 10:49, 30 April 2009
The purpose of the Excel Add-in is to display the results of reports created in SmartSimple, in an Excel spreadsheet.
1. Click the SmartSimple Reports button.
The report list is displayed.
All the reports you are permissioned to see are displayed in this list.
2. Double click in the required report.
If there are any parameters required you will be prompted.
3. Click the OK button.
The report is displayed in the Excel Spreadsheet.
4. You can now apply any formatting that you need.
System Requirements
- This feature requires Microsoft Excel 2000 or higher installed on your computer
- Access to the Internet is required plus a valid SmartSimple username and password.
Setting Security
This feature stores user information in a file: SETTING.INI, in the Microsoft Office/Office/ folder on the C: Drive. If this folder is protected, then the system will not work.
The user must have write access to this folder in order for the Excel Add-in to operate.
