Click to view the SBC Online User Manual
|05/14/19:||Running the SBC under Excel 2016 on Windows|
|02/21/19:||Issues running the SBC under Excel 2011 on the Macintosh|
|06/15/18:||v3.99: Box Score update command halts during processing|
|04/06/18:||Import Dialog File Selection Problems|
|04/01/18:||Zoom slider inactive after launching the SBC on Windows - fixed on v3.98|
|02/01/16:||Adjusting SBC Toolbar Icons Sizes Under Windows Ribbon|
|01/05/16:||SBC Support under Excel 2016|
|09/21/15:||Schedule Manager and Web Site Link Conflicts|
|05/17/15:||Configuring the SBC Under Excel 2007 and later on Windows Platforms|
|05/10/15:||Line Score Processing Bug in Version 3.70|
|03/12/15:||WARNING: Rogue Web Sites Claiming Keygens and Uninstallers for the SBC|
|02/21/15:||One Step Web Site Command Changes (Version 3.60 and greater)|
|11/28/14:||Problems running the SBC under international versions of Excel|
|10/13/13:||Possible crashes using the SBC under Excel 2008 on Mac Platforms|
|07/14/13:||Using the the SBC Under Excel 2008 or 2011 on Mac Platforms|
|10/16/10:||SBC Issues With Excel 2004 (Mac) and Security Update 11.6.1|
Click on any graphic for a larger image
05/14/19: Running the SBC under Excel 2019 on Windows
SBC version 4.00 has been recently tested and is operational running under Excel 2019 on Windows. Note the following limitations:
* Microsoft Office 19 restrictions
02/21/19: Issues running the SBC under Excel 2011 on the Macintosh
06/15/18: Version 3.99: Box Score update command halts during processing
During Box Score updates, the command may result in suspension of operation with a debugging dialog box:
This was the result of debugging code that was not removed in the 3.99 release. Simply hit the Continue button to resume operation. This has been fixed in version 3.991.
04/06/18: Import Dialog File Selection Problems
The SBC attempts to configure the file selection dialog box to show just the relative file types (file type filtering) for each import operation. On some versions of Excel, this function does not always work correctly. If you are not able to select a desired file, terminate the dialog box and disable the Source File Filtering option in the Edit / General Preferences command. Then, rerun the import command.
04/01/18: Zoom slider inactive - fixed on 3.98
Version 3.98 fixed the problem where the screen zoom slider (lower right hand corner of window) was inactive/dimmed after completion of SBC initialization on some Windows version of Excel.
02/01/16: Adjusting SBC Toolbar Icons Sizes Under Windows Ribbon
On the Windows platforms, the default SBC toolbar icons and tooltip sizes may be tool small. They can be changed by the following Windows procedure:
This will adjust the sizes of the menu text, tooltips text, and tooltip icons. This will apply to Excel as well as other windows and applications.
09/05/15: SBC Support under Excel Office 2016
Starting with v3.80, the SBC release has been verified on the Excel Office 2016 General Release on the Windows platform.
It should be noted that Excel 2016 on Windows does not co-exist with previous versions on the same machine. Attempts to run the SBC will likely fail. Best to run Excel 2016 on a different machine with no other versions of Office.
The Excel Office 2016 Release for Mac OS X is not supported as some critical functionality for SBC operation has been dropped.
09/21/15: Schedule Manager and Web Site Link Conflicts
Starting with v3.80, theSBC implements a new Schedule and Results Manager capability. The user can optionally generate a web page and link to the schedule if desired during One Step Web Site processing.
If enabled, this may cause conflicts with user-generated links to schedules (ie: using the User Notes area or an optional link to an external schedule) as the Schedule link label and filename are automatically generated. The One Step Web Site command and associated Preferences commands will warn the user if a conflict exists and to take corrective action.
05/17/15: Configuring the SBC Under Excel 2007 amd Later on Windows Platforms
With the advent Excel 2007, the user needs to be aware of the following compatibility and configuration issues for proper operation of the SBC. Note that in Excel 2007, the File tab is not present - Clicking on the Excel globe performs this function. In Excel 2010 and beyond, the File tab was restored.
1) Security Configuration Changes
Excel must be configured to allow the SBC to execute from the directory where the SBC files are intended to be stored. This is performed in the Trust Center under the File/Options/Trust Center/Trusted Locations tab.
In addition, macro security must be configured to allow the SBC to execute. This is also performed in the Trust Center under the File/Options/Trust Center/Macro Settings tab:
The default setting is Disable all macros with notification. This is the safest setting.
The version 4 workbook, worksheet and macro sheets should be unblocked as shown in the File Block Settings dialog.
2) First Time Launch of the SBC
After the Trust Center configuration has been completed, launch the SBC by clicking on the SBC_Macros.xlm file. After Excel loads, you may see an alert warning about the file format, answer Yes.
You will then see a security prompt to allow macro execution. Depending on the version of Excel, the alert will show in the message bar at the bottom of the window or just under the Ribbon area. Click on the Enable Content button to continue.
A standard file open dialog will appear. Select a Team Worskheet file to open. The SBC should launch normally at this point. The file will be verified that it is a Team Worksheet.
After you see the SBC READY message in the message bar, quit the SBC via the File/Quit Softball Team Calculator menu command. No need to save the file at this point.
This sequence only needs to be performed once. Subsequent launches of the SBC can then be performed by clicking on a Team Worksheet.
3) Menus and Toolbar Locations
With the Excel Ribbon Interface, the SBC menus and toolbar now appear under the Add-Ins tab.
If the Add-Ins tab is not visible, make sure it is enabled via the File/Options/Customize Ribbon dialog.
3) Saving Team Worksheet Files
When saving an SBC team worksheet, make sure to save it in the orginal .xls format. If you save it in the new .xlsx format, you will not be able to re-launch the SBC.
05/10/15: Line Score Processing Bug in Version 3.70
Version 3.70 has a bug that causes incorrect lines scores to be retrieved on box score web pages and when printing. Manual retrieval of a selected game line and box score was not affected. A fix has been incorporated into Version 3.71.
03/12/15: WARNING: Rogue Web Sites Claiming Keygens and Uninstallers for the SBC
There appear to be a number of web sites that show up in searches that claim to have key generators or uninstallers for the SBC.
Do not utilize these sites !!!
They are rogue sites that likely contain viruses that will infect your system if installed.
The SBC does not require a password or key to install, use or uninstall the program. To uninstall the SBC, simply drag the SBC_Macros.xlm file to the trash.
02/21/14: One Step Web Site Command Changes (Version 3.60 and greater)
Starting with version 3.60, web sites generated via the One Step Web Site Command generate Responsive Design web pages. This means that there are no longer separate web pages for desktop and mobile browsers. If you have team web sites that were generated with Version 3.50 or earlier, it it suggested that they be regenerated using version 3.60. Check any user-defined links to insure that they will point to the correct web pages.
11/28/14: Problems running the SBC under international versions of Excel
This problem appears primarily on non-English versions of Excel. It is a result of major differences and lack of some critical functionality in the underlying macro engine in the internationalized versions of Excel.
The SBC does not have language support for non-English languages.
The solution is to try to obtain an English language version of Excel (Mac or Windows), preferably a US version.
10/13/13: Possible crashes using the SBC under Excel 2008 on Mac Platforms
On version 3.40 and prior, the SBC may crash on startup due to a defect in the way Excel/2008 manages custom toolbars. A fix for this is has been incorporated into Release 3.50
07/14/13: Using the SBC Under Excel 2008 and 2011 on Mac Platforms
Review the SBC User Manual Section 1 for more details.
1) User Interface Changes
With the advent of Excel 2008, Excel has implemented a new Ribbon User Interface. This is a hybrid approach with the SBC menu bar still appearing at the top and a ribbon similar to that found on Windows versions of Excel. The SBC floating toolbar is still available.
The support of Page Break Preview mode has been dropped in these versions. The SBC will automatically switch to Normal View when launched under Excel 2011. This needs to be performed manually under Excel 2008.
2) Excel 2008 Limitations
This version of Excel dropped support of some ciritical macro functionality needed to support user defined web graphics objects placed in the content area of a Team Worksheet. Any web graphics that were present in previous Team Worksheets will still be visible on the screen and on printed pages. However, they will not appear on web pages. The web graphics are still retained in the Team Worksheet for SBC compatibility with other versions of Excel. Support for masthead logo graphics is still supported.
10/16/10: SBC Issues With Excel 2004 (Mac) and Security Update 11.6.1
Microsoft's 11.6.1 security update released 10/12/2010 has caused a major issue with previously created Excel worksheets. The SBC team worksheets will experience this problem and will fail to open or launch the SBC macros.
On 10/15/2010, Microsoft released the Microsoft Office 2004 for Mac 11.6.2 Update that fixes the problem. The SBC works properly with this revision and beyond.
Filing a support request for the SBC
Every effort has been made to validate the functionality of the SBC under a variety of versions of Excel®, multiple releases of Microsoft Windows® and Macintosh® operating systems and a variety of popular web browsers.
If you still have difficulty, send a support request email.
Please try to capture the following information:
© 2000-2019 Softball Team Calculator
Lightbox2 - Courtesy of Lokesh Dhakar