Unable to open workbook or insert view

Client computers with both .NET Framework 1.1 and 2.0 installed cannot open view-based workbooks with existing views and cannot insert new views due to a third-party issue that prevents Excel from using the required .NET Framework 2.0. Excel Services fails with an "Unable to create Geac.PM.Decision.DWObjects.DWView" error. For more information on this issue, see http://support.microsoft.com/?id=908002.

You can work around this issue by creating a configuration file that forces Excel to use .NET Framework 2.0:

  1. Use a text editor to create a file that includes this content: 
    <?xml version="1.0" encoding="utf-8" ?>
<configuration> 
<startup> 
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>
  2. Name the file Excel.exe.config and place the file in the same directory as the Excel.exe file.

Warning: A client computer may include add-ins or smart tags that are not compatible with .NET Framework 2.0. Since an application cannot run two versions of .NET Framework at the same time, the Excel.exe.config file will cause these add-ins and smart tags to fail. To successfully use these add-ins and smart tags, you can allow Excel to use .NET Framework 1.1 by temporarily renaming the configuration file. When you need to use Excel Services, remember to change the name back to Excel.exe.config.