Query, Share and Manage Excel workbooks on LAN, Internet

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

Add-in A-Tools AI 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 AI?

(*) Support AI in Excel - Use human language to let AI work, with OpenAI and Google Gemini.

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:

Use AI in Excel, Speech to text

Share Excel files on LAN, internet with many 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).

(Multiple users cannot edit or delete each other's data in the same Excel sheet, lock data)

(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.

 

Work with Google Sheets on Google Drive, Excel Online on OneDrive, DropBox from Excel

+ Sync data from Excel to Google Sheet, Excel Online, DropBox in real-time or sync the entire file.

+ Get data from Google Sheets, Excel Online to Excel using the BS_CLOUD function. See detailed instructions here.

 

(VBA programming tutorial to create a Userform to save data to Google Sheets or Excel Online)

Using AI in Excel - Use human language to let AI work. Click here

 

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.

(Formula run SQL in Excel)

(Function BS_SQL to query data in Excel: The function returns an array that automatically resizes as the condition changes.)

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.

(Create dynamic grouped reports using the BS_SQL function with the GROUP and FOOTER properties)

(Use function BS_SQL with 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, ...

 

 

How to calculate value with conditional color like Excel function for value: SUMIF, COUNTIF, SUMPRODUCT, .... A-Tools support: BS_SUMIFCOLOR, BS_COUNTIFCOLOR, BS_SUMPRODUCTIFCOLOR, BS_SUBTOTALIFCOLOR, you can calculate value with condition color.

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