WIXLIB

Spreadsheet server user guideHome〉Spreadsheet〉Spreadsheet Server〉Gallery Report This Spreadsheet DetailsCategorySpreadsheet. TopicSpreadsheet server free download. AuthorSophia SwinburnePostedWed, Dec 25 . Individuals and organizations need a monthly spreadsheet template to organize monthly financial activities. There is reallyno way you can properly make up what you spend against the money you earn except using this template. You can get a free spreadsheet template from the Internet. Once you've downloaded it, insert information about your financial plans. The template can also be used by companies, individuals, and companies. Thebest thing about free templates is that you can use them to record any kind of information, and what's more, they are completely free. More examples of Today's Picks 1 Global Software, Inc.'s Spreadsheet Server User Manual Version 14.6 Worldwide Headquarters 3301 Benson Drive Raleigh, NC USA EMEA/APACHeadquarters 100 Saint Paul's Churchyard London, EC4M 8BU UK 2 Spreadsheet Server All Rights Reserved. No part of this work may be reproduced in any way or by any means , graphic, electronic or mechanical, including photocopying, recording, taping or information storage and retrieval systems , without thewritten permission of the issuer. Microsoft, Excel, Windows, Outlook, Office, Word, Access, and SQL Server are all registered trademarks of Microsoft Corporation. IBM, DB2, iseries, and Lotus are trademarks or registered trademarks of International Business Machines Corporation. GroupWise is a registered trademarkof Novell. BPCS and INFINIUM are registered trademarks of Infor Global Solutions in the United States and/or other countries. JACK HENRY's trademarks are owned by Jack Henry & Associates, Inc. Lawson and Movex are registered trademarks of Lawson Software, Inc. and its affiliates. Oracle, JD Edwards andPeopleSoft are registered trademarks of Oracle Corporation and/or its affiliates. Salesforce is a trademark salesforce.com, inc. and is used here with permission. SAP is a registered trademark of SAP AG. Trade names are covered by service marks, trademarks or registered trademarks of the respective manufacturers inthe United States and/or other countries. Global Software, Inc. is not in any way associated with or related to the respective pros of the abovementioned trade marks, trade names or service marks, unless expressly stated otherwise. The respective owners of the aforementioned trademarks, trade names or service markshave not been approved, certified or approved by any of the global software, Inc. products for use in relation to their respective products. Although all precautions have been taken in the preparation of this document, the publisher and the author shall not be liable for any errors or omissions or for damages resulting fromthe use of the information or programme contained in this document, and code that may be attached to it. Under no circumstances shall the publisher and the author be liable for any loss of profit or any other commercial loss that has been incurred, directly or indirectly, in this document. Printed: May 3, 2017 3 Contents ITable of Contents Part I Spreadsheet Server Introduction 1 1 General. General ledger report Report 2 2 Query /. Query Designer Overview 3 3 Propagation. Manager Overview 4 4 Spreadsheet. Re-tempering overview 5 5 Profile. Scheduler Overview 6 Part II Installation and Registration 7 1 Additional .Components 7 2 Register. Add-in 10 3 Uninstall. Process 11 Part III Navigation 12 1 SS Ribbon SS right . Click the context menu for Part 18 IV Sign On 19 V Part Control Panel 20 VI SS Settings 24 Part VII GL Reporting 40 1 Build a. Template 41 Build tem plate . GXL Using Clear / No Clear Worksheet 46 BuildTem Plate . GXL Using Insert Colum n Data Only 47 Build Tem Plate. GXL Using Shift Worksheet Data 48 2 Formula. Assistant 49 3 GXL Formula . account values 55 4 account. Segment syntax 56 5 List accounts. for GXL formula 57 6 Expand/Collapse. Row GXL Formula 58 7 Find . Segment 60 8Spreadsheet. Server Segment Lists 62 Create/Maintain. Segm ent Lists 62 Using Segm ent. Lists or hierarchy values GXL form ula 66 SSLDESC form . ula 67 View or modify. Segm ent List Values from w ithin Excel 68 9 Calculations Calculations Options Global Software, Inc. 4 II Spreadsheet Server - Version14.6 View/ Refresh . Local Cache 70 View /Refresh. Global Cache 72 Disable/Enable. Shape ula calculations drill down. Functionality 75 General grid features Copy/Export. Entries 78 Copy to Excel. w ith Layout 79 Drill Dow n to Detailed . Account balances 81 Drill Dow n to amount. m arized Account Balances82 Drill Dow n to Multi-Colum. n Account balances 83 Drill Dow n uz Magazines . per Account(s) 84 Drill Dow n to Journal . Entry lines 86 Drill Dow n to detail. Journal Entry Lines 87 Drill Dow n to subsystem . Detail 88 Drill Dow n on Selected. Ad hoc Miscellaneous. Features 90 List Accounts Account SecuritySS Validation Generate Account Details of the current page 94 Expand details. Reports (GXE) 95 Expand account. Balances 96 Extend to Logs Hide Line s w. ith Zero Balances 102 Reset Host Server. Connection 103 SS View Log Upgrade Segm. ent List 106 Upgrade Workbook Analyst Analyst Sign. 108 in thegeneral ledger. Specifics 110 build. Tem plate 111 GXL GXD BPCS BPCS Sign On BPCS 4.05 Ledger . Specific by 116 BPCS 6.02 Ledger. Specifis 118 BPCS Ledger. Specificity by specificity 120 BPCS Build a. Tem plate GXL 122 BPCS GXL BPCS GXD BPCS 6 GSV BPCS GXA BPCS Load Local . DataData. Warehouse 131 Data warehouse. 131 data in stock. Ledger specifics 132 data warehouse. Build Tem plate 133 GXL data warehouse . GXL 134 data warehouse. GXD Designer. GL Global Software, Inc. 5 Content Content Dizaineru dizainers dizainers III GL. Pierakstīties 137 GL . Virsgrāmatasspecifi 138 GL. Veidot Tem plate 140 GXL GL . GXL Infinium Infinium Infinium Infinium Infinium Infinium Sign. Virsgrāmatā 143. Specifi s 144 build. Tem plate 145 GXL GXD Jack . Henry 151 JH Sign On JH Ledger Specifika JH Build Tem . plate 154 GXL JH GXL JH GXD JD Edwards JDE Sign On JDE LedgerSpecifika JDE Build Tem . plate 161 GXL JDE Form ula. Asistents GXL 162 JDE Form ula . Asistents GXSALES 164 JDE GXL JDE GXD JDE GXSALES JDE GXSALES. Drill Dow n 171 JDE pamatlīdzeklis. Atlikumi 172 JDE FASTR Ziņojums . Konversijas Lawson Law dēls Sign . Uz 175 Law son Ledger .Specifi u 176 Law dēls Build . Tem plate 177 GXL Law dēls GXL Law dēls GXD Movex Movex Sign On Movex Ledger . Specifi pa specifiskumu 182 Movex build. Tem plate 183 GXL Movex GXD Oracle Oracle Sign On Oracle Ledger . Specifi u 189 Oracle Build a. . Tem plate 191 GXL Oracle GXL Oracle GXD Segment Mapping PeopleSoft PSoft PSoft PSoft PSoft Sign On Ledger . Specifi pa 199 Build a. . Tem plate par GXL 200 GXL Global Software, Inc 6 IV Spreadsheet Server - Version 14.6 PSoft GXD SAP SAP Sign On SAP Ledger Specifika SAP Build A Tem . plate GXL 207 SAP GXL SAP GXD VIII daļas vaicājumuizveidei. Veidne vaicājumiem 214 SAP Explorer Formula . Palīgs vaicājumiem GEXQ . Formula GEXD. Formula 230 GEXD mērķauditorijas atlase. Cell 233 GEXD Mērķauditorijas atlase . Range 235 GEXD Orientēšanās . 237. tabula Izpildīt SAP. T-Code w ithout GEXD Form ula 239 Execute Query . w ithoutGEXD form ula GEXS . Formula GEXI. Formula izpildīt. Meklēt lejupielādi. Vaicājumu exchange 251 IX daļas vaicājumu noformētāja vaicājums. Designer Architecture 253 QD Ribbon Explorer fails. System Panel 258 Vaicājuma izvēlne Vaicājuma skata paneļa tabulas izvēlne Tabulas lauks. Menu 262 Field ListPanel Field List Menu Builder Panel Custom Buttons Param eters Panel SQL Text Panel QuickText Panel SAP Panel QD Settings Connections Update Query Izvēlne 262 Field List Panel Field List Menu Builder Panel Custom Buttons Param eters Panel SQL Text Panel QuickText Panel SAP Panel QD SettingsConnections Update Query . Savienojumu izveide. Jauna vaicājuma saglabāšana. Query pirmo reizi Pievienot tabulas Izveidot . Attiecības Global Software, Inc 7 Saturs V 8 Izvēlieties . vai Izveidot vaicājuma laukus 286 tiešos laukus. no avota tabulas 287 Pievienot attēlu. Lauka tips 288 Priekšskatījuma datipiešķir aizstājvārdus. uz laukiem 290 Aprēķinātā izveide/rediģēšana. Lauki 292 Lauku atlasīšana. no tabulas 293 Izveides datums. Lauki 295 Izmantojiet CASE. Builder 297 GEXD Row Get Values Add Criteria Hard Coded Criteria Create and Use. Param eters 307 Parametri . programmā Query Designer vsExcel 307 Standard. Parametri query designer 308 izmantot parametru, lai . Piegādāt datu bāzes/bibliotēkas nosaukumu 310 Smart parms. Kritēriji Entry Noteikumi 311 Smart . query designer 312 parameters. In Excel 314 Sub query Colum. n 315 Assign Query GEXD Lim its Create. Creating Totals (Group By)Query. GEXQ lauks SQL. Shell function to execute. Query Legacy. Ad hoc Query Query. Management 326 Dow nload or . Send query query Queries 327 Text Query. Definition QD View. Log 330 X Part Distribution Manager DM Navigation DM Ribbon DM Right Click. Creating DM Settings for context menu.distribution control worksheet add specification. Maintain Lines. Distributing specification lines. Specifications Miscellaneous. DM Items 349 Merge Data Narrative Reporting Distributor . Tape 353 Distributor. Formula Assistant 354 Preview Narration. Reporting Results Global Software, Inc. 8 VI SpreadsheetServer - Version 14.6 Cache Address . Book 357 local address. List of DM View Log Part XI Spreadsheet Writeback SWB. Oracle Ribbon. APIs Set Backing up 363 Oracle APIs -. Build a Tem plate 364 Single API. Method 365 Template Method Builder Sheet Loader Sheet Generic. Table Backscript Setup 372Eyebrow Se Database Generic Tables . - Build Tem plate 376 Generic Tables . - Data Row s 379 Generic Tables . - Writeback Definition Exam ple 380 Generic Tables . - Rem ove Writeback Database Database Connection 381 Generic Tables . - Delete Writeback Definition Writeback . Processing 384 previewwriting s/a. and Process Selected Row s 385 Validate Writebacks Run Writebacks Generic Tables. Product 393 SWB View Log Part XII Profile Scheduler Address . Book Cache Propagation. Manager Custom. Table loads 401 to create query custom view. s Load. Local INF Load. Local JDE Schedule. Jobdefinition. Mapped Discs Miscellaneous. PS Items 425 PS Settings PS View Log Database Managem. ent 429 Index Global Software, Inc. 9 Spreadsheet Server Introduction 1 1 Spreadsheet Server Introduction Spreadsheet Server, Powered by QueryExchange (formerly known as Executive Dash or EDASH) is thebackbone of Global Software, Inc.'s Microsoft Excel-based Automation Guide, which allows organizations to obtain live and dynamic access from their respective ERP or relational databases from Excel to data such as : GL, AP, AR, PO, Inventory, Manufacturing, Rent Roll, Sales, Projects, Time & Attendanceinformation and more Spreadsheet Server converts Excel into a tightly integrated analytical tool for any ERP system. Users can use the strength of their spreadsheets with seamless dynamic integration into their information, as well as powerful detail capabilities to the lowest level of detail. This allows users to create arange of reports, from simple ad hoc workbooks to complex views of critical business data dashboard type. The spreadsheet server turns off data re-pouring or downloading data into a spreadsheet and makes the spreadsheet an integral part of the application. While maintaining the full functionality of an Excelspreadsheet application, Spreadsheet Server allows the user to mix GL and non-GL data into one worksheet. The powerful spreadsheet function (chart, text formatting and sorting) and dynamic information combination provides the foundations for accurate, elegant income reporting, balancing and other criticalstatements. Spreadsheet Server Components A spreadsheet server application consists of four components: the Excel add-in for financial reporting across all ERP platforms - spreadsheet server formulas used in Excel allow users to create reports using familiar business and accounting terms rather than technicalspecifications. Query Designer - a user-friendly tool that allows users to create and maintain queries on any relational database. You can combine these queries with preconfiguring formulas in a single Excel spreadsheet. Query Exchange - Online Store queries from which the user can download the selected queries to

the query designer, and then use them in Excel. Using the Query Exchange SmartPak feature is a way to group preconfiguring queries together. Distribution Manager - By eliminating time-consuming tasks for printing, copying, or creating attachments to get information only to your end users, this tool automates reportingscheduling directly in Excel. Spreadsheet Re-enticing is a powerful tool used to write data from an Excel spreadsheet to a database. Profile Scheduler – This component allows you to schedule various tasks, such as the recipient manager address book cauling, refreshing workbooks, distributing recipient managerworkbooks, and loading local database files. Spreadsheet Server Licensed Features Access to each component depends on the user-licensed features. General ledger - Access the general ledger-related formulas in the Excel Add-in. Query – Access the formulas associated with queries in the Excel add-in componentand access the query exchange. Query Designer - Access to query designer and query exchange components. Distribution Manager - Access to the recipient manager component. Backdempkey - Access to the spreadsheet backlist component. Restricted licensing – Restricts access to various spreadsheet serverfeatures (i.e. creating a template, formula assistant, segment lists, segments, list accounts, data validation, and workbook upgrades). Global Software, Inc. 10 2 1.1 Spreadsheet Server – Version 14.6 General Ledger Reporting Review General Ledger (GL) Reporting feature of Global Software, Inc.'s Spreadsheet Serverconverts familiar spreadsheet software (Excel) into a closely integrated analytical tool for financial systems. A spreadsheet server uses certain formulas to retrieve general ledger data in a spreadsheet and gives the user the ability to drill down in detail. Functions (*) Retrieve dynamic balances based on ledger-definedformats and time periods (period, quarter, start of year, etc.) Retrieve balances using single value, mask, range, value list, segment list, hierarchy value field, Drill down to Account balances Drill down to the accounts selected for journal data Drill on journal lines for the selected journal entry Drill on the detail of theselected journal drill down to the detail of the subsystem Copying and pasting data in spreadsheets or other documents (*) The available functions vary depending on the selected ledger that you're processing. Benefits Use spreadsheet skills and write reports within minutes eliminate requirement for IT or super-users tocreate/change financial statements No more downloading or re-insutiation spreadsheet data Reduce the number of days to close financial books; save only 3 hours per month per user and the investment is paid in less than 12 months Publish executive quality reports from the current spreadsheet software Increase theefficiency and timeliness of the budget process Create complete Executive Information System Create ad hoc reports or perform account analysis within minutes Save financial user time by combining reporting, account request and log request per application; Create a business analysis free time Perform corporateconsolidation with immediate access to dynamic data Reduce external audit time, making it easier, instant access to financial data with full detail options to match accounts Quickly and easily spill accounts from one, central application 11 Spreadsheet Server introduction Query/Query Designer overview As an integral partof Global Software, Inc.'s Spreadsheet Server, Query Designer allows users to create queries that are then used in Excel to ineemly retrieve critical business data and return data for use in a spreadsheet. When you use queries on a spreadsheet server, you use three components to design and maintain queries: querydesigner, visual tool. The Exchange query, the online depository of queries, is used to download the selected queries to the query designer and then use them in Excel. The Excel Add-in component allows the user to query the designer queries in a spreadsheet by returning dynamic business data. Access to eachcomponent depends on the features licensed by the user. Features and benefits Get dynamic data in enterprise databases (including Microsoft Access, DSN system databases, IBM iseries, Oracle, Salesforce, SAP, and Microsoft SQL Server) Create a query using a system that provides the Import/Export Scanner tool topreconfiguring queries from various sources, including global exchange run query on fly to ensure that data is displayed as business needs to dictate simple file system storage and listing the tree query structure, Similar to Windows Explorer Use data from a spreadsheet as parameters for a query Easily create formulasin spreadsheets using the system provided in Create Template and Formula Assistant Perform dynamic calculations with a multilevel pivot to view related details Copy and paste detail data into spreadsheets for global software, Inc. 12 4 1.3 Server Spreadsheet - Version 14.6 Manager Overview As an integral part ofGlobal Software, Inc.'s Spreadsheet Server, Distribution Manager is a powerful tool used automate the distribution of documents by using, printing, or file archive. Distributing spreadsheets can be a very time-consuming and laborious task. Consider the following issues: there are many worksheets in the workbook, butyou only need to distribute them. The workbook contains external references to other workbooks that are required to calculate the correct numbers, but you do not need to split the linked sheets. Split worksheets contain formulas that are derived from a specific Excel add-in (such as a spreadsheet server) or a specificExcel macro. Recipients do not have an add-on or macro installed on your computer. Workbooks must be encrypted to allow/ unauthorised opening of or change content. Hours are spent organizing, summarizing, calculating, copying, and pasting worksheets for each reporting cycle. Distribution Manager takes intoaccount each of the above problems and provides users with a simple and time-saving solution. Recipient Manager divides controls mounted directly into workbooks. The number of distribution records is limited by only the number of rows in a spreadsheet. After you create distribution lines, users can visually see andmanage who receives what they receive from a single worksheet. 13 Spreadsheet Server Introduction Spreadsheet Writeback Overview As an integral part of Global Software, Inc.'s suite of data analytical solutions, Spreadsheet Writeback is a powerful tool used to write data from an Excel spreadsheet to a database. Thespreadsheet backkey provides an interface so that data that you burn to worksheets can be returned to the database table. Currently, data can be written back to any generic table that the user has write permissions to, or to an Oracle database using oracle's public API. General table backwards: During the initial setupprocess, the database in which you write data is identified. This database connection is assigned to each worksheet, so you can assign a different database to each worksheet in the workbook. After you define a database connection, the user selects a table to write data to and identifies the columns in the table topopulate the data from the spreadsheet. The back-to-back definition has a header row that defines the table name and table fields, as well as two columns to contain the date and status of the last backd up. A worksheet can contain one or more back-swallowing definitions. After you define a return definition, the data youwant to write to the database is entered into the spreadsheet. The number of re-rows is limited by only the number of rows in a spreadsheet. Text in SWB> means that the row must be written back. After you enter the data in a spreadsheet, you can run the backwarding. When you run writebacks, the user can run aseparate backresp after which the following back writebacks, all back writebacks on the selected worksheet, or all writebacks on the entire workbook. Additionally, the user can type all rows of data in the database or only the selected rows of data. Oracle API Writebacks: When writing back oracle using Oracle API, theprocess is for the general table, but with different differences. Some of the differences include assigning a database connection to a separate write-back program instead of a page and using text swbapi > to represent a write-back queue. Global Software, Inc. 14 6-1.5 Spreadsheet Server – Version 14.6 ProfileScheduler Overview Profile Scheduler component of Spreadsheet Server allows scheduling various jobs, such as caching distribution manager address books, refreshing workbooks, distributing Distribution Manager workbooks, and loading local database files. Available profile types: Address Book Cache – Cachesaddress book lists used in Recipient Manager to reduce the time it took to load the address book. Distribution Manager - Refreshes the selected workbooks with the specified replace values and/or distributes the selected recipient manager workbooks. NOTE: Scheduling Distribution Manager with Profile Scheduler andOffice 365 is currently not supported. Custom Table Loading – Downloads table and table data from the source database to the destination database, which allows you to optimize the calculation speed. Load Local Database Files – downloads account balance information to local databases, allowing you to optimize thecalculation speed. This is a great opportunity to produce Spreadsheet Server reports when books are closed and analytical tasks are performed in real time. The time spent loading local databases is greatly offset by a significantly reduced spreadsheet calculation time. Because the Profile Scheduler is working withMicrosoft Windows Task Scheduler, see the following diagram to get the necessary user rights: The profile type that creates and manually runs job scheduling, job scheduling, which runs a scheduled job, While you are logged on to a scheduled job execution while you are logged on to -OR, you log on and run the job onanother account that is not logged on to the address book cache, there is no specific custom table load requirement, or Load local No Special Requirements Distribution Manager Administrator Privileges No Applicable No Special Requirements Note: To verify that the user is part of the Administrator group, from the top ofthe table go to Control Panel>Administration Tools>Computer Management. In the Computer Management panel of the tree view, go to Local Users and Groups>Groups. Select Admin and view the properties. Verify that the user is in a group or, if necessary, add the user to the group. Mapped disks that are usedin any part of the profile planner process, including distribution manager (that is, file save folder) or spreadsheet server (that is, file locations), must be defined on the Mapped Disks tab when you run and schedule a job for specific profile types. 15 Installation and registration 2 Installation and registration 2.1 Components7 REQUIRED COMPONENTS Application Configurator Single Application Configurator installation installation The server must be filled in by an administrator, and each user must be created and assigned a valid license key in the configurator before using the spreadsheet server. Contact your security administrator toobtain the network location for the security and connection file. Microsoft.Net Framework Microsoft.Net Framework is a prerequisite for a spreadsheet server. This component must be installed before you install the Spreadsheet Server Application application in Microsoft Visual Studio Tools for Office Microsoft VisualStudio 2010 Tools for Office Runtime is a prerequisite for the spreadsheet server. If it is not installed, the spreadsheet server setup engine will prompt you to install it. Microsoft Access Database Engine 2010, Microsoft Access Database Engine 2010 Redistribution, is a prerequisite for a spreadsheet server. If it is notinstalled, the spreadsheet server setup engine will prompt you to install it. Microsoft Visual C redistribution is a prerequisite for a spreadsheet server. If it is not installed, the spreadsheet server setup engine will prompt you to install it. OPTIONAL COMPONENTS Based on the type of database that the spreadsheet serverand/or query designer connects to, additional software components may be required before processing. Contact your IT department to determine what needs to be installed. Data Source Name (DSN) Database From desktop, select Start>Control Panel>Administration Tools>Data Sources (ODBC) to create theDSN. Global Software, Inc. 16 8 Spreadsheet Server - Version 14.6 iseries DB2 Database Both ODBC and OLEDB provider components ibm iseries Access Windows (formerly called Client Access Express) must be installed on each user's PC. Run IBM iseries Access for Windows to determine whether odbc and OLEDBprovider components are installed. Microsoft Access database You do not need to load additional software to ensure connectivity to an Access database (.mdb) file. Microsoft SQL Server Database Additional Software does not need to be loaded to provide connectivity to the SQL Server database because the ODBCdriver used is already loaded in Windows. Oracle Client Do not need to load additional software to provide connectivity to the Oracle database because Global provides a direct connection. However, if you want to connect to an Oracle database using an Oracle Client ODBC provider, you must install oracle client softwareon each user's computer. Oracle Client configures the local service name and assigns the appropriate host name and port number. 17 Installation and registration of sap database 9 To access the SAP database on a spreadsheet server, you must install SAP Netweaver 7.0 or a later version. The disk space requirementson the server are negligible (less than 10 Meg). Sap adapter is imported into the system using SAP transport in the /ZGLBSOFT/ reserved name. This is a SAP approved mechanism for third-party software that does not provide standard/custom customer system. No additional server or server hardware is required. ForADDITIONAL COMPONENTS by using the Distribution MANAGER Distributor for Outlook Add-in for Excel 2010 (or later versions) users by using Outlook, the Distributor For Outlook add-in is a prerequisite for distribution manager. If it is not installed, the Distribution Manager settings feature will force the installation ofThe Distributor of Outlook AddIn before allowing the user to choose Microsoft Outlook Exchange as the server option. For Microsoft collaboration data objects for Excel 2007 users who use Outlook, Microsoft Collaboration Data Objects (alias CDO) is a prerequisite for Distribution Manager. If it is not installed, theDistribution Manager Settings feature will force the CDO installation before allowing the user to choose Microsoft Outlook Exchange as the server option. ADDITIONAL COMPONENTS by using the Profile Scheduler Microsoft command-line utility in SQL Server, the Microsoft command-line utility, SQL Server, is anadditional component; However, if it loads on the same computer as the Profile Planner, the Profile Planner component uses tools to try to increase processing speed and performance. Global Software, Inc. 18 Spreadsheet Server - Version 14.6 Register Add-In During the Installation Process, the system automaticallyregisters and initiates the Spreadsheet Server add-in for Excel. If for any reason the Spreadsheet server is not registered during installation, it must be registered manually. Additionally, if multiple users use the spreadsheet server on the same computer, future users must manually register the add-in. The registrationprocess registers and initiates an add-in for Excel. Note: If the add-in is not registered on your computer, the spreadsheet server will not be displayed in the list of available add-ins available in Excel. 1. On the desktop, click Start>All Programs>Global Software Spreadsheet Server>Register Add-in. The RegisterSpreadsheet Server Add-in panel appears. 2. Click OK to register the add-in. A panel appears that indicates that the registration process is complete. 3. Click OK. Uninstalling is only allowed to completely remove the product from your computer. 1. Make sure Excel is not open. 2. On the desktop, click Start>Controlpanel>Add or Remove Programs -or-Programs and Features. 3. Select the spreadsheet server program and click Change/Remove - or Uninstall. Global Software, Inc. 20 12 3 Spreadsheet Server - Version 14.6 Navigation Spreadsheet Server uses the following navigation methods to process functions in an Excelspreadsheet. Each function is not always available from each method. Spreadsheet Server Ribbon (see SS Ribbon) Spreadsheet Server Right Click Context Menu (see SS Right Click Context Menu) NAVIGATION TIPS: All manual navigation convention does not have a TIP indicating the different paths available toaccess the function. 21 After you install the Spreadsheet Server navigation SS and initiate it as an add-in in Excel, a custom spreadsheet server (SS) ribbon is added to Excel. Use the SS Ribbon to access/process application functions. The Element Description Calcu

Spreadsheet server user guide Home〉Spreadsheet〉Spreadsheet Server〉Gallery Report This Spreadsheet DetailsCategorySpreadsheet. TopicSpreadsheet server free download.