Softball / Baseball Team Calculator

Support

06/14/11: Configuring the SBC Under Excel 2007, 2010 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, the File tab was restored.

 

1) Security configuration has been changed. 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. Each time the SBC is launched, the user will be prompted to allow macro execution. This is the safest setting. The alert will show in the message bar at the bottom of the window:

security alert warning

Click on the Enable Content button to continue.

 

2) With the new Excel Ribbon Interface, the SBC menus and toolbar now appear under the Add-Ins tab:

SBC menus under ribbon UI

If the Add-Ins tab is not visible, make sure it is enabled via the File/Options/Customize Ribbon tab.

 

3) 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.

10/16/2010: 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 the current revision which is 11.6.4.

Getting Support 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 that is not documented or where the SBC does not deliver the expected results, check the errata in the DOWNLOADS tab. 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: support@sbc.aces-softball.com so make sure that your email client allows this address.

Please try to capture the following information:

  • SBC version information*
  • Version of Microsoft Excel®*
  • Operating system platform and revision (Microsoft Windows® or Macintosh OS X®)*
  • What operation that was attempted
  • Is the issue repeatable ?
  • The sequence of events that led to the problem
  • The contents of the message bar
  • Any any alert messages that were posted
  • in the event of a macro error fault, capture the information reported and the line number
  •  
  • * Can be obtained from the File / About Softball Calculator command.

© 2000-2011 Softball Team Calculator

     Lightbox2 - Courtesy of Lokesh Dhakar