General
Is there a 64bit version available?
Yes! Spreadsheet Studio supports both the 32bit and 64bit flavours of Excel.

What version of Spreadsheet Studio do I have installed?
You can find your version of Spreadsheet Studio by following these steps:

  1. Open Excel
  2. Click on the Studio tab
  3. Click the About button
  4. Click the Licence button
  5. The version will appear on the bottom left of the Licence form

Which versions of Excel are supported?
We support both the 32bit and 64bit versions of Microsoft Excel 2007 and 2010.

Are you affiliated with Microsoft?
We have no affiliation with Microsoft.

Will you release a version for Excel 2003?
Spreadsheet Studio depends on functionality only available in Excel 2007 and 2010. We will not be releasing a version of Spreadsheet Studio for Excel 2003 or earlier.

How do I report a bug?
Before reporting a bug, please make sure you are running the latest version of Spreadsheet Studio as the bug may already have been fixed. If you are running the lastest version, we have a Bug Submission Form under the About menu at the top of the site. When you submit a bug report, please include instructions on how to replicate the bug. We appreciate your assistance in improving Spreadsheet Studio.

Installation and Uninstallation
How do I disable or enable Spreadsheet Studio?
Depending on your version of Excel, Spreadsheet Studio can be enabled or disabled as follows:

Excel 2007

  1. In Excel, select the Office Orb at the top left of your Excel window
  2. Select Excel Options
  3. Change the Manage dropdown on the bottom right of your screen to “COM Addins” and click Go
  4. Check or uncheck Spreadsheet Studio
  5. Click OK

Excel 2010

  1. In Excel, select the File menu at the top left of your Excel window
  2. Select Options
  3. Change the Manage dropdown on the bottom right of your screen to “COM Addins” and click Go
  4. Check or uncheck Spreadsheet Studio
  5. Click OK

How do I uninstall Spreadsheet Studio?
Spreadsheet Studio can be uninstalled is the same manner as most software. Go to your windows control panel and choose to “Add or Remove Software”. Spreadsheet Studio will appear in the list of installed software and can be uninstalled by clicking the uninstall button.

Troubleshooting

Spreadsheet Studio has disappeared from my Excel, how do I get it back?
Depending on your version of Excel, Spreadsheet Studio can be enabled as follows:

Excel 2007

  1. In Excel, select the Office Orb at the top left of your screen
  2. Select Excel Options
  3. Select Add-Ins
  4. Change the Manage dropdown on the bottom right of the Add-Ins screen to “Disabled Items…” and click Go
  5. If Spreadsheet Studio appears in the list, select it and click the Enable button. Otherwise click the Close button.
  6. Change the Manage dropdown on the bottom right of your screen to “COM Addins” and click Go
  7. Make sure that Spreadsheet Studio is checked
  8. Click OK.

Excel 2010

  1. In Excel, select the File menu at the top left of your screen
  2. Select Options
  3. Select Add-Ins
  4. Change the Manage dropdown on the bottom right of the Add-Ins screen to “Disabled Items…” and click Go
  5. If Spreadsheet Studio appears in the list, select it and click the Enable button. Otherwise click the Close button.
  6. Change the Manage dropdown on the bottom right of the Add-Ins screen to “COM Addins” and click Go
  7. Make sure that Spreadsheet Studio is checked
  8. Click OK

Collaboration Tools
How do I add standard comments by default?
You can set standard Excel comments as the default comment type by following these easy steps:

  1. Click on the Studio Tab
  2. Click the Setting button
  3. Click on the Collaboration Tab
  4. Select Standard Comments as the Default comment type
  5. Click OK to save your settings

Where do you store the Advanced Comment data?
The data enabling Advanced Comments is encapsulated within the comment. If you delete the comment, you delete the associated data.

How do I add advanced comments by default?
You can set Advanced Excel comments as the default comment type by following these easy steps:

  1. Click on the Studio Tab
  2. Click the Setting button
  3. Click on the Collaboration Tab
  4. Select Advanced Comments as the Default comment type
  5. Click OK to save your settings

Visualisation Tools

“Too many unique formats” error
Excel has a limit on the number of formats that can be present in workbook. A format is defined as unique combination of font type, font colour, font size, fill, pattern, border, protection etc. When you exceed this limit, Excel can become unstable and may stop responding.

To avoid this problem, you will need to simplify the workbook. This can be done by deleting any unnecessary sheets, rows and/or columns. Remember to save the simplified workbook and to close out of Excel before reusing the workbook.

There are also some 3rd party tools that can automatically reduce the number of formats in workbook by removing orphaned formats. One such tool, available for free, is xlstyletool.