Installation Components

This article describes the installation components for Spreadsheet Server, like the Product Suite, the Excel Add-In and the Application Configurator.

Spreadsheet Server Suite consists of these components:

• Upgrades: Spreadsheet Server Excel Add-In
• Upgrades: Application Configurator
• Upgrades: Cloud Connector (only applicable to cloud customers)
• Excel Add–In: for financial reporting across ERP platforms. Spreadsheet Server formulas used in Excel allow users to create reports using familiar business and accounting terms, rather than technical specifications.
• Query Designer: a user-friendly tool that enables users to design and maintain queries over any relational database. These queries can be combined with preconfigured formulas in a single Excel spreadsheet.
• Query Exchange: an online repository of queries from which the user may download selected queries to the Query Designer, then utilize them in Excel. Using the Query Exchange, the SmartPak feature is a method to group preconfigured queries together.
• Distribution Manager: eliminates the time consuming tasks of printing, copying, or creating email attachments; this tool automates the scheduling of report distribution from directly within Excel.
• Spreadsheet Writeback: a powerful tool used to write data from an Excel spreadsheet to a database.
• Profile Scheduler: allows for scheduling various tasks, such as caching the Distribution Manager address book, refreshing workbooks, distributing Distribution Manager workbooks, and loading local database files.

This document references the steps required to install or upgrade the Excel add-in and, optionally, Application Configurator.

Excel Add-In

The Spreadsheet Server Excel Add-In is the main component for users, consisting of the add-in, as well as other functions outside of Excel that are used to support and enhance the Spreadsheet Server application.

Note: Excel 2013 is no longer supported. Users require Excel 2016 or higher to receive continued support from insightsoftware. Excel's legacy Shared Workbooks feature is not supported. For more information, see Microsoft Support: About the Shared Workbook Feature, here.

Application Configurator

Application Configurator allows the creation of a central point of administration for Spreadsheet Server users. It is used to create and maintain:

• License keys, profiles, and security settings for all users.
• Database connection user IDs and passwords.
• Application settings.
• Administrative passwords.

Only Spreadsheet Server administrators need to install this component. It is a separate application and does not require the Excel Add-In portion of Spreadsheet Server.

Note: The Excel Add-In is required for the Viewpoint Profile Creation Wizard data validation test.