Add Ins For Excel

Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them. Are you looking for information about Office Add-ins based on HTML, CSS, and JS? See full list on docs.microsoft.com. Sep 01, 2020 Free Excel add-ins and tools on Excel Dashboard School! Boost your work productivity and save your time! No trials, 100% power! Latest releases: DataXL Productivity Suite v7.22 – 2021-03-15. DataFX UDF Library for Excel add-in v8 – 2021-06-14. Free Organizational Chart Builder for Excel v1.12 – 2020-09-01. Add-ins are different extensions of excel which when enabled they activate when the excel is started and a user can use its functions, excel has various different add-ins and they are in the options section of the file tab, the first box shows the enabled add-ins in the system and if the user wants to enable more add-ins we need to click on manage add-ins.

Add Ins For Excel 2016
Office Add-ins Platform Overview

How to Repair Microsoft Excel
What to do if add-ins do not run

If you are getting error messages like 'error in module 1', 'unspecified error', or 'undefined reference', the problem is not with our add-ins! It is a problem with the installation of Office. Random Excel crashes, especially when Excel is closing, are also an indication of a bad installation of Office.

We have tracked some crashes of Excel 2010 and above to still having Excel 2003 on the PC and Excel 2003 being corrupted. Do the repair on all releases of Office you have, even if you are not using a particular release and just kept it installed.
Another cause we have found for random crashes are partially corrupt workbooks. How do they get corrupt? More ways than one to count. One we have noticed is corrupt workbooks made outside of Excel. Sometimes they work fine. Sometimes they done. The solution in this case is to realize it is workbook dependent. Then, the solution is to create new workbooks. And doing copying of sheets to a new workbook is not the solution. Do copy and paste special values, and recreate formulas and graphs.
The number one cause is still a bad or corrupt installation of Office, which the steps below provide solutions.

The following are the steps to take to do the fix this problem by fixing Microsoft Office. Keys to fixing Excel are:

Do the multiple reboots as instructed. A royal pain, but essential.
Run the Temp File Deleter, all options, multiple times, as instructed.
After rebooting, never open Excel or any other Office programuntil instructed to do so. Opening Outlook to do a quick check of your mail during the process will screw up the fixes. The same goes for Power Point to fix a presentation, etc. Office programs use common files. Opening any part of the Office Suite may prevent the steps from working.
Do the repair of Excel last. Do not skip it.

If the message you are getting is an out of memory error or not enough resources, then either you do not have enough memory on your PC, you are running too many programs, multiple instances of Excel, or have many COM or VBA add-ins installed. See memory problems for how to fix.

REPAIR STEPS BY EXCEL VERSION

Window 10 and Office 365 or Office 2016, Excel 2019

Reboot (important!) - this insures any file used by Office is fully released.
Right click on the Windows start button, and select Control Panel, Programs and Settings.
Find Office and either click on it and then Change up at the top, or right click and select Change.
A repair options dialog will appear. There is both a quick repair and an online repair.
Do the quick repair, Open Excel and see if all is fixed.
If not, close Excel and do the online repair

Excel 2013 / Office 365

Reboot (important!) - this insures any file used by Office is fully released.
Open Excel
Click File, Account
In the right-side panel that appears, on the right side is the setting of your Office update. Confirm that it is set to update automatically. If not, click the button there and set to update automatically.
If you had to change the button to update automatically, let it run any update.
If you had to run an update, close and re-open Excel and then see if the problem is fixed.
If the problem is not fixed, then:
- Reboot AGAIN (important!) - this insures any file used by Office is fully released.
- Go to Programs and Features in Settings, Control Panel
- Right click on Office 2013 and select 'Change' (do not double click as that presents only the option to un-install)
- You are presented with two options: A quick repair or an online repair. Try the quick repair first. If it does not solve, then reboot again and do the online repair. Do not skip the reboot!

Excel 2010 Users:

Reboot (important!) - this insures any file used by Office is fully released.
Run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
Install Service Pack 2 for Office 2010. For some users, the Service Pack will not recognize your version. We have posted this issue to Microsoft and are hoping for resolution. If you cannot install, do the Control Panel/Repair steps below then try to run the service pack.
- SP2 32 bit version (most users):
Run the Temp File Deleter again
Go to the Control Panel. If Windows XP, open Add/Remove Programs. If Windows 7, it is Programs and Features
Right click on Office 2010 and run the Repair or Change option (sometimes service packs do not do a perfect job)
Open Excel and all should work fine

Excel 2007 Users:

View, manage, and install add-ins in Office programs - Office ..

Reboot (important!) - this insures any file used by Office is fully released.
Run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
Install the latest service pack, SP3. Service Pack 3 (SP3) for Office 2007. Do from this link. Do not Open Excel.
Reboot again!
Run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
Do a Repair of Excel:
- Re-open Excel for the first time
- Click the Office Button, Excel Options, and Resources again
- To the right of 'run Microsoft Office Diagnostics', click the button 'Diagnose'.
- If Office advises that Diagnostics were recently run, click the button 'Run Diagnostics Again'. Installing any service pack or upgrade almost always causes bugs in Office. Even though Diagnostics may report that no problems were found, it will find and fix some problems (we've seen it happen).
- If a description of why you should run Diagnostics appears, click the Continue button
- Close the Resources dialog and Excel as soon as a Microsoft Office Diagnostics screen appears. This will not close the Diagnostics screen. Then click the Run Diagnostics button. If a choice of diagnostics to be run is given, select all of them.

Excel 2003 Users:

Reboot (important!) - this insures any file used by Office is fully released.
Run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
Install the latest service pack, SP3. Service Pack 3 (SP3) for Office 2003
Reboot
Run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
Do a repair of Excel:
- Open Excel
- Select Help, Detect and Repair.
- A dialog will appear with an option to restore your shortcuts. Make certain it is checked.
- Click the start button on this dialog. Even though repair may report that no problems were found, it will find and fix some problems (we've seen it happen).

If all the above fails, re-install of Office. To maximize your chance of success, do it this way:

Make certain you have your CDs and license keys before doing these steps.
Reboot (important!) - this insures any file used by Office is fully released.
Go to Control Panel, Select Office and un-install Office (do not re-open any part of Office after the reboot).
- Excel 2013 users: Un-installing may result in a lost license and Microsoft will not replace. Contact them first.
Reboot again (this finishes the un-install).
Run the Temp File Deleter. Run all the options. Run after the reboot.
Reboot again. Yes, again! Reboots insure your PC is clear of any residual actions from the above.
Do another complete un-install (yes another uninstall) using the un-install optionsfound at this Microsoft page. Use Option 2 is far easier than Option 1.
Re-install Office. Do not open Excel, Outlook, or any part of Office when done.
Reboot again and run the Temp File Deleter a second time. Run all options.
Do not open Excel or any part of Office. Install the latest service pack per above instructions. (it was removed when Office was removed).
Reboot again. Do not open Excel or any part of Office. Run the Temp File Deleter a third time. Run all options.
Open Excel. for the first time and immediately do a repair of Excel (per instructions above).
Close Excel.
Re-install the add-ins.
Open Excel and see if the add-ins work.
If the add-ins still do not work, reboot again and run the Temp File Deleter a third time. Run all options.
Run Windows Update. This will see if Microsoft has released any special fixes for Office and Excel that are needed on your PC.
See if the add-ins work.

If the above does not solve:

If one of our products, let us know. We will work with you to fix even though it is an Office problem. We can connect, with your permission, to your PC and hopefully determine the cause and hopefully fix.
If the problem is caused by another vendor's products, ask them if they have an upgrade to the product you purchased.

Ultimate Dashboard Tools is the most powerful dashboard add-in for Excel. Use it to improve your Dashboard. No coding is required. Always in a hurry? Discover UDT and boost your productivity! A new milestone has been reached. We proudly announce that we passed over 25 000 customers!

UDT v10 is available on Windows and Mac.

High Performance

UDT instantly improves your dashboard’s performance and visual quality. So forget configuration headaches, and enjoy the most amazing results!

Easy To Use

UDT automatically applies the best practices. You don’t need to be a rocket scientist to set it up and benefit from it.

Great Support

Support is the backbone of our product. The Support Team knows UDT by heart and is ready to assist if you have any questions or issues with our plugin.

Don’t Just Take Our Word for It

One day I got in contact with UDT, and I must say: From day 1, I was surprised by all the benefits you can have to build up your report to visualize your data. A straightforward way to amaze your Board of Directors.

Didier Brackx

CEO, Xenturion BVBA

UDT is an amazing customization tool; you can come up with gauge charts for various KPIs in no time. Therefore, all risk managers are encouraged to use UDT-powered visualizations.

Sarkis Kawoukjian, CPA

Head of Internal Audit – Fertitrust S.A.

UDT consistently opened my mind to new ways of visualizing my data and customizing presentations to fit my audience. UDT has a human touch; I reached out when I needed assistance and received more in return. I remain a fan.

Ivo Mekkole, MBA

Sr. Analytics Product Owner, Humana

Check the add-in in motion

Features and Functions

ONE TIME FEE
Flexibility: Create almost any kind of KPI dashboard
Automated: Various chart types in a single click
Easy to use: Zero programming skills required
Lifetime FREE updates
Compatibility: Excel 2010, 2013, 2016, 2019 and Office365
Supported OS: Windows (32/64 bit)
Please read the FAQ, before buy the tool
Latest release: v10 / Apr 16, 2021

Gauge and Dual Gauge Chart (up to 12 zones)
Traffic Light Widgets
Radial Bar Chart
Polar Area Chart (Excel 2013+ required)
Bullet Chart
Waterfall Chart (vertical and horizontal)
Org Chart Creator
Score Meter Chart
Advanced Sales Funnel (Excel 2013+ required)
TreeMap, Mekko Chart, Variance Charts
Cycle Plot

Documentation

Summer Sale!

One-time fee

Automated live Gauge charts

Everybody already knows the gauge chart. They are so popular that they couldn’t be left out from the newest Microsoft BI tool and PowerBI. These are solutions capable of creating real-time presentations.

We have already said that there are no limits; any number of the gauge can be used on a workbook. Fully automated operation and stability are its characteristics. The latest version of UDT enables 12 zones for gauges!

Dual Gauge chart

There are a number of ways of showing variance to target.

The latest release of UDT provides a dual gauge chart that is simple to read and gives meaningful comparisons between plan and target or actual vs. budget.

Radial bar chart

A radial bar chart (also called a circular bar chart) is eye-catching visualization. In future releases, we’ll fully support the latest data visualization trends in Excel! The main function is comparison.

Polar area chart

The polar area diagram is like a pie chart, but the sectors are the same angle and differ by how far they extend from the center. This chart type is best used to plot cyclical data.

Advanced Sales funnel chart

The sales funnel chart is an important element of the UDT. A funnel diagram is a visualization tool that is able to show various effects. You can use up to 12! stages.

Automate repetitive tasks with our funnel graph so that your sales team can spend less time on data entry! Check our video tutorial about the sales funnel!

Traffic light widgets

We’ve created traffic light widgets in Excel to display charts that highlight exceptional performance or project status in your reports.

Waterfall and Rotated Waterfall Charts

Add Ins For Excel 2016

Advanced Bullet charts

The bullet chart is a special kind of chart. Our long-time desire (not only ours but our user’s wish also) has come true with the introduction of this tool. Excel default doesn’t support its use. We have bypassed this problem with some VBA tricks.

Highlight the columns containing the base data. After this, you don’t have to do anything but click on the bullet chart icon on the ribbon. Your chart is done! The chart is not only able to handle three categories but a maximum of eight!

Cycle Plot

Mekko chart

Marimekko chart (aka mekko chart) is the newest chart type of the UDT add-in. In a mekko chart, the column widths show one set of %, and the column stacks show another set of %. If you want to create this complex chart manually, you’ll need some time and patience. From now the mekko chart is fully supported!

Quick Variance Charts

Office Add-ins Platform Overview

We can create horizontal and vertical charts with a push of a button. We only need to highlight the plan and actual data rows. After this, from the ribbon, the appropriate icon can be used. We reach the needed result in a blink of an eye.

It is good to know that the dynamic chart principle is in effect here too. If we change the value of one cell, then the chart will change in real-time.

About Ultimate Dashboard Tools

UDT add-in is a fully portable solution, and it’s based on native excel charts using advanced programming. You can share your work! Just send your presentation to your boss. No additional installation is necessary. Your client/partner will be able to view it. Take Control of your metrics using various chart widgets!