Softball/Baseball Team Calculator


Click on any graphic for a larger image

06/14/19: Running the SBC under Excel 2019 on Windows

SBC versions 4.00 and beyond have been tested and are operational running under Excel 2019 on Windows. Note the following limitations:

  1. Applies to Excel 2019 under Windows/10 ONLY*.
  2. Excel 2019 cannot run under Windows/7*.
  3. If you install Excel 2019, you must first de-install older versions especially 2016 as they cannot co-exist on the same system*.
  4. The SBC cannot run under Excel 2016 or 2019 on the Mac platform due to major limitations in the Excel macro support.

* Microsoft Office 19 restrictions

02/21/19: Issues running the SBC under Excel 2011 on the Macintosh

  1. SBC version 3.98 addressed the remaining known stability issues running under Excel 2011 on the Mac.
  2. Unlike other versions of Excel, the Open and Save dialogs do not retain the directory that was selected during a previous Open or Save dialog. It always will revert to the directory where the SBC was launched. There is no obvious fix for this.
  3. On completion of program startup, the SBC may lose window focus. Clicking on the window will restore focus.
    This can be caused by previous use of the Excel Developer tab and the VBA editor. Sometimes, clicking on the Developer tab and opening and closing the VBA editor will fix this.
    Also helps to insure that the "Home" tab has been clicked.
  4. Occasional crash may occur when a Team Worksheet is opened for the first time. This can occur when it had been used with a different version of Excel, especially crossing from Windows to Mac versions. Relaunching the Team Worksheet will usually fix this.

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:

v3.99 Box Score command bug

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:

  1. Right-click on any area of the Windows desktop
  2. Click on the Personalize item
  3. In the Personalization window, click on Window Color
  4. In the Window Color and Appearance window, select the Menu item
  5. Adjust the Size item as desired
  6. Hit Apply to view the change
  7. Hit OK to make it permanent

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.

modifying SBC toolbar icons size

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 Excel 2007 globeperforms 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.

trust center file locations dialog


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:

trust center macro settings dialog

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.

trust center 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.

SBC File Format Warning

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.

security alert warning

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

SBC menus under ribbon UI

With the Excel Ribbon Interface, the SBC menus and toolbar now appear under the Add-Ins tab.

Excel customize ribbon options dialog

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.

return to top

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.

return to top

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 encounter a situation where the SBC does not deliver the expected results, check the Revision History and Errata document. Next, check the section on Troubleshooting in the SBC User Manual.

If you still have difficulty, send a support request email.

Replies will originate from:
Insure that your email client and spam filters allow this address.

Please try to capture the following information:

  1. SBC version information*
  2. Version of Microsoft Excel*
  3. Operating system platform and revision
         (Microsoft Windows or Macintosh OS X)*
  4. What operation that was attempted
  5. Is the issue repeable ?
  6. The sequence of events that led to the problem
  7. The contents of the message bar
  8. Any any alert messages that were posted
  9. in the event of a macro error, capture the information
    reported in the dialog box including the fault description and the line number
    * Can be obtained from the File / About Softball Calcolator command.
return to top

© 2000-2019 Softball Team Calculator

Lightbox2 - Courtesy of Lokesh Dhakar