Go Back   Computer Forums > Classifieds: Buy | Sell | Trade
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 09-18-2011, 10:46 PM   #1
Beta Member
Join Date: Sep 2011
Posts: 1
Default Add-in A-Tools Sharing and Management Excel Workbook on the network

A-Tools is an add-in software which runs on Microsoft Excel. A-Tools has the following functions :

Sharing Workbooks, Worksheets, Ranges on the network:
With A-Tools allows editing and managing Excel workbook on the network. Users to manage Excel workbook powerful on the network, allow connect to the spreadsheet over TCP/IP (not full share folder – Excel’s way), manage connections to the data ranges, setting rights for each user group: read only, edit, limit how many people are connected ,....,When data is changed on worksheet then other computers in the network are updated immediately (after about ~ 1 millisecond).

Query data on the worksheet: Add-in A-Tools can create dynamic reports by using the functions to query the database (DB) with T-SQL language. It also allowers users to connect to the internal and external database such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird,… for instance. The “SQL Builder” helps users to create a query formula (with BS_SQL function) easily and efficiently. Users are able to create highly sophisticated worksheets which are filtered according to various conditions and associated with different data sources. In that way, accuracy, stability and high speed are ensured.

The main functions

• Create Server (Excel Server)
• Manage Server
• Create ranges in worksheet for sharing on the network
• Build Groups and Users to access/connect to
• Setup rights for groups
• Manage list of users connected
• Connect to Server (Excel Client)
• Manage Clients
• Connect to the Excel range to read/edit/format
• View list of users connecting and chatting
• Function support for editing and updating data on server
• Managing Excel reports on the network (LAN), supporting commands: Check; Approve; Dis-Approve. Under each command the user is not allowed to copy data, print, modify report.
• Manage the history Excel files in the server, users can open them again if they have the right.
• Query data on worksheet
• Connect to the external database: Excel, Access, MySQL, Firebird,…
• Create dynamic report
• Build query formula BS_SQL() by “SQL Builder”
• Create function for Function BS_SQL()
• Query and link data to Server by BS_SQL() function
• Create statistical formulas with multiple conditions
• Convert text, number to words
• Developers can program their applications with A-Tools.

Menu A-Tools

With Microsoft Excel 2007 or more advanced: After starting Mircrosoft Excel 2007 and selecting menu A-Tools, the function of the A-Tools is shown as below:

With Microsoft Excel 2003 or lower:

A-Tools running on versions of Excel 2000/XP/2003/2007/2010 or higher.

Watch on Youtube: How to share Excel Workbooks, Worksheets, Ranges on the LAN and Internet

For more details and Download Add-in A-Tools, visit at Add-In A-Tools Editing and Management Excel Data on the network Query data on worksheet
atoolspro is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 01:07 AM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0