ActiveData is an All-In-One add-in suite that brings advanced database like analysis, data mining, manipulation and conversion to Microsoft Excel. ActiveData provides powerful dialog driven data analysis and manipulation features, many of which were up until now, only available in specialized forensic accounting and auditing tools that cost thousands of dollars per user.
Jun 14, 2018 - How to Load the Microsoft Excel Data Analysis ToolPak in Excel 2007-2013. You can access it by clicking “Data Analysis” in the “Data” tab. Active Data for Excel Microsoft Excel - From Beginner to Expert in 6 Hours / EXCEL DASHBOARD REPORTS. Active-Data for Excel Start Download Active Data For Excel Demo. Click on one of the following links to learn more about ActiveData For Excel's extensive feature set.
ActiveData is designed for Excel users of all stripes and supports features such as summarize, pivot, worksheet join / merge / match / compare, gap / duplicate detection, stratification, digital analysis using Benford's law, aging (date analysis), database like queries on worksheets, statistical sampling (random, stratified random and monetary unit / PPS), cell cleansing and conversion as well as a variety of navigators that allow you to manage your workbooks, worksheets, selections and ranges. Other features include worksheet split by group or date, column split and concatenation, calculated columns, row tagging, dialog driven formula builders, global workbook find and replace, workbook indexing, hyper-linked table of contents generation, multiple-tables-at-once import from ODBC / SQL databases, one click worksheet duplication and popup statistics.
Full Specifications What's new in version 5.0.507 Version 5.0 supports Excel 2003 - Excel 2019 (including Office 365) and is available for both the 32 and 64-bit versions of Excel. English, French, German and Japanese versions of the software are available. General Publisher Publisher web site Release Date January 24, 2019 Date Added January 27, 2019 Version 5.0.507 Category Category Subcategory Operating Systems Operating Systems Windows NT/2000/XP/2003/Vista/Server 2008/7/8/10 Additional Requirements Microsoft Excel 2007, 2010, 2013 and 2019 including Office 365. Download Information File Size 11.61MB File Name ActiveDatax86.exe Popularity Total Downloads 20,602 Downloads Last Week 2 Pricing License Model Free to try Limitations 30-day trial Price $129.
Hi, I cannot get the Data Analysis button to appear in the Data tab of excel 2010. I have ensured the Analysis ToolPak is installed and active for excel: Also that in the trust centre add-ins are not disabled: I have tried uninstalling the add-in exiting Excel and then re-installing but to no avail.
No other users seem to be able to get this working either. We are Win 7 with Office 2010. I had a quick look through rsop.msc to see if any restrictions were being applied but didn't see anything obvious. Any help gratefully received! Following further research, it appears a GPO setting may be preventing this. We have recently migrated to Win7 and a new GPO template applied to a new OU structure.
The GPO setting that could be preventing the add-in from showing is here: User Configuration/Policies/Administrative Templates/Microsoft Office 2010/Global Options/Customize/Disable UI extending from documents and templates I have raised a change to see if this GPO setting can be tested and will report back if it resolves the problem. Following further research, it appears a GPO setting may be preventing this. We have recently migrated to Win7 and a new GPO template applied to a new OU structure. The GPO setting that could be preventing the add-in from showing is here: User Configuration/Policies/Administrative Templates/Microsoft Office 2010/Global Options/Customize/Disable UI extending from documents and templates I have raised a change to see if this GPO setting can be tested and will report back if it resolves the problem.
THanks Thanks alot - this is also working for Office 2016/365.