View source for Generating a Report in Excel

{{Deprecated}}

'''[http://www.smartsimple.com/DotOrg/flash/Generating_a_Report_in_Excel_viewlet_swf.html View it Here]'''

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.

[[Image:Excel8.png]]
 
The report list is displayed.

[[Image:Excel9.png]]
 
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|username]] and [[Password|password]].

==Setting Security==

This feature stores [[User|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|user]] must have write access to this folder in order for the Excel Add-in to operate.