Query, Share and Manage Excel workbooks on LAN, Internet

Add-in A-Tools: Query, Share Excel file on LAN, internet with multiple users

Add-in A-Tools allows sharing and managing Excel files on LAN, internet. Someone can open the Excel file in the server at the same time for editing and saving. The client connects to the server by TCP/IP protocol (does not share the full directory - the way Excel does), the server manages the connection by restricting users, setting permissions for each user group: read-only, edit, limit the number of people who can open the sheet, ... When the data in the spreadsheet is changed, other computers on the LAN, the internet will be updated immediately (after about ~1 milli seconds).

What can I do with Add-in A-Tools?

1) Share Excel files over Network between users. Client connects to server using TCP/IP protocol, login with IP address, domain name

2) Limit users to worksheets, address ranges, workbooks

3) Restrict users to edit only certain cells in that sheet

4) Restrict users to print, copy sheets

5) Some users can edit the worksheet at the same time, but cannot delete or change other people's data. User as leader can change the data of users in the same group.

6) Users with "Approve" permission can browse rows in the sheet or the entire sheet, so all users in the network cannot edit once the row or sheet has been approved.

7) Chat with others in Excel.

8) Query the data on the sheet using the executable SQL language. Connect to any database on your computer and link the data to the sheet. With the BS_SQL function, you can create professional reports at high speed with large data in sheets, very easily with drawing and dropping with mouse on SQL Builder.

Add-in A-Tools can generate dynamic reports using functions to query a database (DB) with the T-SQL language. It also allows users to connect to internal and external databases such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird, ... for example. "SQL Builder" helps users to create query formulas (with BS_SQL function) easily and efficiently. Users can create highly complex sheets that are filtered by different conditions and associated with different data sources. That way, high accuracy, stability and speed are guaranteed.

A-Tools is a powerful add-in for Microsoft Excel with functions: share excel files on LAN, internet. Query functionality by executing T-SQL on the sheet for report generation - high speed with big data on the sheet. It has the following main functions:

Add-in A-Tools allows sharing and managing Excel files on LAN, internet. Someone can open the Excel file in the server at the same time for editing and saving. The client connects to the server by TCP/IP protocol (does not share the full directory - the way Excel does), the server manages the connection by restricting users, setting permissions for each user group: read-only, edit, limit the number of people who can open the sheet, ... When the data in the spreadsheet is changed, other computers on the LAN, the internet will be updated immediately (after about ~1 milli seconds).

(Synchronize Excel data in Real Time)

(Excel Server sets up Excel files, sheets to share on LAN, Internet)

Excel Client can connect to the server (any computer running "Start Server" on the "A-Tools" menu in Excel). Open some sheets they have shared and have limited permissions. Several users can open one excel sheet simultaneously for editing, chatting with limited permissions from Excel server settings.

 

Query data on a worksheet using SQL language. That's the power of quick reports for Excel:

Add-in A-Tools can generate dynamic reports using functions to query a database (DB) with the T-SQL language. It also allows users to connect to internal and external databases such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird, ... for example. "SQL Builder" helps users to create query formulas (with BS_SQL function) easily and efficiently. Users can create highly complex sheets that are filtered by different conditions and associated with different data sources. That way, high accuracy, stability and speed are guaranteed.

(SQL function on worksheet)

Create Dynamic Reports in Excel with GROUPS of columns with Add-in A-Tools

If you want to create reports in Excel with speed and power, the Add-in A-Tools is a good choice! This video demonstrates how to summarize and concatenate data with the BS_SQL, GROUP_CONCAT  function.

(Function GROUP_CONCAT in Add-in A-Tools)

Add-in A-Tools supports SQL Builder to create forms in Excel with seemingly simple clicks! Report generation is very easy by drag and drop sheet inside/left side, right join any sheet to query data using T-SQL Statement.

Advanced Input (Support drop-down list to select list with multiple columns to search and filter, date on dialog,...): Data validation list in Microsoft Excel, you can create a drop-down list with a column in the select list but it cannot filter the list when typing the value. With Advanced Input, you can select items in the drop-down list, you can search and filter data easily. If input data with DATE format, you can select date from dialog, ...

 

Programming VBA, VB, Delphi, .NET with Add-in A-Tools with classes (COM objects) in addinatools.dll