BonaVista Systems – Sparklines, Dashboards, Charting for Excel and Microsoft Business Intelligence

You can distribute MicroCharts workbooks as PDF file, as Excel workbook or share it in the web. When you share the workbook, recipients need the free MicroCharts fonts installed.

Back to Trouble Shooting List

The MicroCharts Toolbar does not appear in Excel, Word or PowerPoint

It is possible that the MicroCharts Add-In is disabled.

To re-enable an add-in that has been hard disabled by Excel ,PowerPoint, or Word.

On the Help menu, click About Microsoft Office Excel (PowerPoint, or Word).
Click Disabled Items.
Select the MicroCharts add-in and click Enable.

To re-enable an add-in that has been soft disabled by Excel, PowerPoint, or Word

On the View menu, point to Toolbars, and then click Customize.
Click the Commands tab.
In the Categories box, click Tools.
In the Commands box, select COM Add-Ins and drag it to a toolbar.
Click Close.
On the toolbar, click COM Add-Ins.
Select the check box next to the disabled MicroCharts add-in and click OK.

Back to Trouble Shooting List

The MicroCharts Toolbar does not appear in Excel 2007, Word 2007 or PowerPoint 2007

It is possible that the MicroCharts Add-In is disabled.

To re-enable an add-in that has been hard disabled by Excel 2007, PowerPoint 2007, or Word 2007

In the application, click the Microsoft Office Button.
Click the <ApplicationName> Options button.
In the categories pane, click Add-ins.
In the details pane, locate the add-in in the Disabled Application Add-ins list. The Name column specifies the name of the assembly, and the Location column specifies the full path of the application manifest.
In the Manage box, click Disabled Items, and then click Go.
Select the add-in and click Enable.
Click Close.

To re-enable an add-in that has been soft disabled by Excel, PowerPoint, or Word

In the application, click the Microsoft Office Button.
Click the <ApplicationName> Options button.
In the categories pane, click Add-ins.
In the details pane, locate the add-in in the Inactive Application Add-ins list. The Name column specifies the name of the assembly, and the Location column specifies the full path of the application manifest.
In the Manage box, click COM Add-ins, and then click Go.
In the COM Add-Ins dialog box, select the check box next to the disabled add-in.
Click OK.

Back to Trouble Shooting List

You get a compile error on startup with Excel 2007.

A Microsoft Office 2007 bug prevents the correct execution of MicroCharts.

Go to Office Update Page and install Office 2007 Service Release 1.

Back to Trouble Shooting List

You do not get the Data Source dialog box -or-
You get an compile error in a hidden module.

A windows system update or the installation of another add-in caused a configuration problem of Microsoft Office ActiveX controls.

Go to the current Office installation via the "Start" button, go to the task bar menu "Control Panel", select "Add/remove programs" then you installed Office version
Click “Change” and select the Repair button.
Start Excel and try to use MicroCharts.

Back to Trouble Shooting List

You do not see the MicroCharts toolbar in Excel.

You might have an add-In installed that forces Excel to use a previous .NET framework version (usually .NET 1.1). A typical example is Crystal Ball which runs on .NET 1.1 and which overrules your .NET 2.0 installation when you start Excel.

Copy the file http://www.bonavistasystems.com/Download2/excel.exe.config to the folder on your computer in which the EXCEL.EXE file resides.
Be sure to identify the correct directory and none where only a link to EXCEL.EXE is located. This configuration file ensures that Excel will load .NET 2.0.
Close Excel and restart Excel and try to use MicroCharts.

If the problem persists, you can also try to deactivate or de-install the other add-in which uses .NET 1.1 for a test.

Back to Trouble Shooting List

When I insert a MicroChart, the cell is filled with cryptic characters

This happens when you set the font size lower than 8pt -or- you force Excel with a zoom factor < 100% to scale lower the 8pt. To correct this,

Set the font size to 8 pt+ and the zoom factor >= 100%.

Back to Trouble Shooting List

Excel Automatically Updates Links without Asking

MicroCharts normally updates the links to MicroCharts and other functions automatically. To disable the update links behavior:

Please go to MicroCharts Toolbar > Options > and disable the "suppress update links" option

Back to Trouble Shooting List

I am trying to install MicroCharts on a computer that is not allowed to be connected to the Internet due to data sensitivity. Is there any way around this?

To avoid the registration and connection to the internet,

un-check 'connect to the internet' on the first page of the Installer.

Back to Trouble Shooting List

The MicroCharts toolbar appears in Excel but MicroCharts functions are not available or the MicroCharts dialog boxes do not appear

A configuration problem on your system prevents MicroCharts to register the add-in with Excel. You have to do a manual registration:

In the "Tools" menu of Excel XP or Excel 2003, select "Add-Ins ...".
In the "Add-Ins ..." dialog, click on "Browse".
Select [your program drive]\Program Files\BonaVista Systems\MicroCharts\ MicroCharts.xla
In the "Add-Ins ..." dialog, click on "OK" and close Excel.
Start Excel and try to use MicroCharts.

Back to Trouble Shooting List

You do not see the MicroCharts toolbar in Excel

When "Trust all installed add-ins and templates" is not enabled in Excel the MicroCharts add-in is not loaded

Open Excel
In the "Tools" menu of Excel XP or Excel 2003, select "Tools / Macro Security".
Select the tab “Trusted Publishers”
Check if "Trust all installed add-ins and templates" is enabled. If not, enable it.
Close the dialog box with OK and close Excel
Start Excel and try to use MicroCharts.

Back to Trouble Shooting List

Check whether you have the most recent version of MicroCharts installed.

An outdated MicroCharts version could prevent the correct execution of MicroCharts.

Go to the current MicroCharts installation via the "Start" button, go to the task bar menu "Control Panel", select "Add/remove programs" then "MicroCharts"
Select the hyperlink “Click here for support information”
Check whether the MicroCharts version is 3.0.0. If you have on older version installed, un-install MicroCharts
Download and install the most recent version from MicroCharts Download Page
After installation of MicroCharts start Excel and try to use MicroCharts.

Back to Trouble Shooting List

Check whether your system is updated with all relevant patches (bug fixes, security patches)

Outdated system files could prevent correct execution of MicroCharts.

De-install the current MicroCharts installation via the "Start" button (go to the task bar menu "Control Panel", select "Add/remove programs" then "MicroCharts" and de-install it).
Use Windows Update (in the Extras menu of Microsoft Internet Explorer) to analyze your system and update any missing features.
Run the Microsoft Office Trouble Shooter Tool
If you have Microsoft Office 2003 installed check if you have Service Pack Level 11.0.5614.0. If you have a different Service Pack Level apply Microsoft Office 2003 SP 2
Restart your computer

Download and install the most recent version from MicroCharts Download Page

After installation of MicroCharts start Excel and try to use MicroCharts.

Back to Trouble Shooting List

None of the steps above resolved your problem? - Prepare the Support email

Within your email provide the following information:

Windows version and Windows language and Windows service pack level
Office version and Office language and Office service pack level
Screenshots of any error messages you might receive
A concise description of the problem and what you have done so far to solve it

Send the email to mailto:support@microcharts.net

Back to Trouble Shooting List

Menu:

MicroCharts 3 Trouble Shooting List