What is Spreadsheet Server and how does it function? Spreadsheet Server is a centralized tool for automation and reporting that connects to an ERP database to directly import information into the native spreadsheet environment. It eliminates the need for re-entering or uploading business data by using a preconfigured add-in for Microsoft Excel. It is compatible with various popular ERP systems and allows users to create reports in a familiar workspace and explore ERP details without requiring specialized IT knowledge. The Spreadsheet Server QueryExchange component combines GL and non-GL data in one spreadsheet and offers a library of preconfigured queries that can be aggregated using the Built-in SmartPak. The built-in QueryDesigner allows non-technical users to easily create, design, and manage custom relational database queries. These custom queries and preconfigured formulas can seamlessly work together in one spreadsheet. The spreadsheet server also simplifies report sharing by integrating common workflow operations into Excel through Delivery Manager. Users can perform tasks such as printing, copying orders, and composing emails with attachments, streamlining the delivery process.










