BreezeTree Home Spreadspeed Product Page
Spreadspeed Help Introduction
Range Selector
 Navigation Tools
Xplorer
Favorites
File Operations
Quick Navigation Buttons
 Workbook Tools
Create Table of Contents
Sort Sheet Tabs
Add Multiple Worksheets
Remove Empty Worksheets
Quick Hide / Unhide Sheets
Save Worksheets to Separate Files
Close and Re-Open Last Save
Save a Backup Copy of Workbook
Quick Protect
Quick Unprotect
Hide / Unhide Named Ranges
 Worksheet Tools
Delete Blank Rows
Delete Blank Columns
Autofit Rows and Columns
Reset Used Range
 Range Tools
Split Single Column into Multiple Columns
Split Single Row into Multiple Rows
Concatenate Columns
Concatenate Rows
Transpose in Place
Swap Ranges
 Table Tools
Filtering Records
Join Tables
Merge Tables
Find Unmatched Rows
Extract Columns
Extract Filtered Data
Extract Duplicate Data
Remove Hidden Rows
 Shapes Tools
Select Shapes by Type
Group All
Ungroup All
Extract Text
 Trim Text
Advanced Trim Tool
Trim Selection
Clean Text
Clear Empty Strings
 Change Case
Change Case Tool
Change Case on Selection
Change Name Case
Prefix / Suffix
 Number Operations
Fill Range with Random Numbers
Perform Math Operations in Place
Negate Selected Values
Remove Non-Numeric Characters
Convert Text to Number
Convert Formulas to Values
Round to X Decimals
 Date Operations
Fill Range with Random Dates
Convert Text to Date
Change Date Formats
Date Formats
 Data Operations
Subtotals
Sum and Percentages
Descriptive Statistics
Remove Repeating Data
Fill Repeating Data
Perform Random Sort
Create Validation Dropdown List
 Export Operations
Save Chart to Image File
Save Range to Image File
Save Shapes to Image File
Save Range to Text File
Create HTML Unordered List
Create HTML Ordered List
Create HTML Table
 Format Operations
Reset All Cell Styles
Delete Unused Custom Cell Styles
Selectively Clear Formats
Clear Excess Formatting
Merged to Center Across
Dependency Navigator (Auditor)
Visual Audit (Auditor)
 Audit Reports (Auditor)
Worksheet Comparison Report
Master Audit Report
Cell Errors Report
Circular References Report
Comments Report
External References Report
Hyperlinks Report
Formulas Report
Named Ranges Report
 Inconsistent Formulas (Auditor)
Find Inconsistent Formulas
Flag Inconsistent Formulas
Compare Worksheets (Auditor)
 Hyperlinks Audit (Auditor)
Open Hyperlinks Navigator
Remove Hyperlinks
Convert Hyperlink Formulas
 Comments Audit (Auditor)
Delete All Comments
Remove User Name
Restore Formats
 Support
Spreadspeed Support
Log Files
Troubleshooting
Uninstalling Spreadspeed
How to Buy

Troubleshooting

Spreadspeed Ribbon Tab

If the Spreadspeed ribbon tab does not appear when you open Excel, please follow these steps to troubleshoot the problem.

 

1. Make sure you install Spreadspeed under your login

Spreadspeed does not require admin privileges to install and is installed per-user. If you, or someone from your IT department, logged in under an admin account to install Spreadspeed, it will only be available to the login account - not yours. If this has happened to you, uninstall Spreadspeed and re-install it under your login.

 

2. Check the Disabled Items list

Excel 2010 - 2013

Click the File tab on the Excel ribbon.
Click the 'Excel Options' button in the left menu.
Click 'Add-Ins' in the left menu of the Excel Options window.
Click the 'Manage' drop down, select 'Disabled Items' from the list, then click the 'Go…' button.
If Spreadspeed is listed, select it and click the 'Enable' button, then restart Excel.

 

Excel 2007

Click the Office Button in the upper left corner of Excel.
Click the 'Excel Options' button on the bottom-right corner of the window.
Click 'Add-Ins' in the left menu of the Excel Options window.
Click the 'Manage' drop down, select 'Disabled Items' from the list, then click the 'Go…' button.
If Spreadspeed is listed, select it and click the 'Enable' button, then restart Excel.

 

3. Check the COM Add-ins list

Excel 2010 - 2013:

Click the File tab on the Excel ribbon.
Click the 'Excel Options' button in the left menu.
Click 'Add-Ins' in the left menu of the Excel Options window.
Click the 'Manage' drop down, select 'COM Add-ins' from the list, then click the 'Go…' button.
If Spreadspeed3 is listed, make sure the checkbox next to it is checked.

 

Excel 2007:

Click the Office Button in the upper left corner of Excel.
Click the 'Excel Options' button on the bottom-right corner of the window.
Click 'Add-Ins' in the left menu of the Excel Options window.
Click the 'Manage' drop down, select 'COM Add-ins' from the list, then click the 'Go…' button.
If Spreadspeed3 is listed, make sure the checkbox next to it is checked.

 

4. Check the security settings

 

Excel 2010 - 2013:

Click the File tab on the Excel ribbon.
Click the 'Excel Options' button in the left menu.
Click "Trust Center" on the left navigation panel.
Click the "Trust Center Settings" button.
The "Message Bar" panel should be open by default. Make sure that the "Show in Message Bar..." option is selected.
Next, click "Add-Ins" from the left menu and set the options per the Add-ins Options section below.

 

Excel 2007:

Click the Office Button in the upper left corner of Excel 2007.
On the bottom-right of the popup menu, click the "Excel Options" button.
Click "Trust Center" on the left navigation panel.
Click the "Trust Center Settings" button.
The "Message Bar" panel should be open by default. Make sure that the "Show in Message Bar..." option is selected.
Next, click "Add-Ins" from the left menu and set the following options;

 

Add-ins Options

Option 1:
oCheck the box labeled "Require Application Add-ins to be signed by Trusted Publisher"
oUncheck "Disable notification for unsigned add-ins"
oUncheck "Disable all Application Add-ins"
Option 2: (not recommended)
o Leave all the settings on this panel Unchecked.

 

Excel needs to be restarted for these security changes to take effect. If you selected Option 1, then the next time you restart Excel, follow the steps in Security Warning - Enable Spreadspeed (below).

 

5. Security Warning - Enable Spreadspeed (Excel 2007 and 2010)

If "Require Application Add-ins to be signed by Trusted Publisher" is checked in the Excel Trust Center (see the section above)., you will see a warning when you open Excel after installing Spreadspeed. The actions differ slightly between Excel 2007 and 2010.

 

Excel 2010 - 2013:

If you see the security message shown below, click the "Application add-ins have been disabled" label. (Clicking "Enable Content" will enable only for the current session).

excel-2010-security-1:

 

Excel will show the info screen below. Click the "Enable Content" dropdown and select "Advanced Options".

excel-2010-security-2

 

On the security options dialog, select "Enable all code published by this publisher" and click OK.

excel-2010-security-3

 

Excel 2007:

If you see the security message shown below, click the "Options" button.

excel-2007-security-warning

 

On the security options dialog select "Enable all code published by this publisher" and click OK.

excel-2007-security-alert

 

 

6. Installation - restart required

If Excel was running during the installation, it will need to be re-started again for the Spreadspeed toolbar to display.

 

7. Download website

Did you download the program from www.breezetree.com? The BreezeTree website is the only official site for downloading Spreadspeed. To get the latest version, download Spreadspeed only from www.breezetree.com. Download sites (including popular ones such as download.com and tucows) often host old versions of Spreadspeed. Downloading from any other site is not recommended!

 

If the above checks didn't reveal the problem, please contact BreezeTree support.

 

 



©2014 BreezeTree Software, LLC. All Rights Reserved.