Issues with Excel 2010

ariadne logo FAQ: CoolSpools and Excel 2010

I'm running CoolSpools V6, CoolSpools PLUS, CoolSpools V5 or Slipstream V4 and am having problems opening Excel files in Excel 2010.

There are a number of known issues relating to Excel 2010 opening Excel files created by CoolSpools V6, CoolSpools PLUS, CoolSpools V5 or Slipstream V4 (or any earlier versions of CoolSpools or Slipstream).

These issues are related to, but separate from, those already fixes in respect of Windows 7. See this FAQ answer for further details of known Windows 7 issues and their solution.

Office 2010 (and Windows 7) apply a number of additional validation checks to files when they are opened, (see this Microsoft knowledgebase article for further details), which means that files that could be opened without problems by earlier versions of Excel cannot be opened in the new version. This is not unreasonable, but, unfortunately, diagnosing the cause of these issues is difficult and time-consuming as Office 2010 does not provide any indication as to what problem is preventing it from opening the file, leaving us often (quite literally) looking for a single stray bit in several megabytes of data.

The issues in this area can be categorized at two levels:

  • Files that cannot be opened at all

    On occasions, Excel 2010 will fail to open a file that can be opened quite happily by earlier versions of Excel. Excel may report the file as being corrupt and attempt to repair it. The repair may be partially successful, or may fail compeltely.

    We believe we now have fixes to all currently known issues of this kind.

  • Issues causing Excel 2010 to open files in "Protected View"

    Protected View is a new security feature of Office 2010. When a file is opened in Protected View, a red banner appears at the top of the screen and the user must click OK to enable editing of the file.

    Protected View can also triggered if Office 2010 considers that the file has come from an "unsafe location", such as a network drive, or has been received as an email attachment. There are settings in the Trust Center area of the Excel options which allow you to manage this feature.

    We believe we now have fixes for CoolSpools Version 6 to all currently known issues of this kind, but we will not be able to release fixes to these issues in relation to earlier versions of our software as the changes required would be too extensive.

If you are encountering problems with opening files in Excel 2010, you should first ensure that you have installed the latest fix pack or PTF for the product you are running.

If you continue to experience the problem with files that were created after the latest fix pack or PTF was installed, please raise an issue with us through the support portal.

Please remember that any files that were created before the fix was applied will continue to give problems. The fix can only ensure that newly created files open without problems under Excel 2010. If you cannot recreate the files that are giving problems, you will need to open them with an earlier version of Excel and re-save them before they can be opened by Excel 2010.