Spreadsheet Server is a centralized reporting and automation solution that connects to an ERP database to pull live information into the native spreadsheet environment. Using a pre-configured add-in for Microsoft Excel and compatible for integration with a myriad of popular ERP systems, Spreadsheet Server eliminates any re-keying or repeated downloading of business data. Users are empowered to not only create reports in a familiar workspace, they can also drill-down substantially into live ERP details without specialist IT knowledge. Blending GL and non-GL data into a single worksheet, Spreadsheet Server's QueryExchange component provides an online repository of pre-configured queries that can be grouped together using the built-in SmartPak feature.
In addition, the integrated QueryDesigner promises a user-friendly facility for non-technical users to formulate, design and maintain custom relational database queries. Both these custom queries and those selected pre-configured formulas can be combined to work seamlessly within a single spreadsheet. Spreadsheet Server also aids the sharing of reports by bringing popular workflow operations into Excel, via the Distribution Manager. Here, users can perform printing actions, copying commands and even compose emails with attachments when scheduling a more automated distribution workflow.