Application crashed if i set the data source of excel to "external data connections"

Application crashed if i set the data source of excel to "external data connections"

• siavoshkc

  hi, Luis Bitencourt-Emilio
  The message is:
  The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:
  External data ranges (also called query tables)
  
  
  
  
  
  
  

• TomJ72

  Thanks Luis Bitencourt-Emilio
  
  

• NoEgo

  Can you paste the Exception info that gets thrown What kind of Exception is it and what is in the Exception.Message

  
  
  

• Dennie-DeTi

  So it seems like the workbook you're attempting to load has an unsupported feature (namely Query Tables/external data ranges).  You can view a full list of unsupported features for this version here: http://msdn2.microsoft.com/en-us/library/ms496823.aspx

  In this particular case you have a table that has an external data source.  In order to load the workbook you will need to remove this table, convert it to a PivotTable, or use UDFs to grab the data and return it to Excel instead.

  While some external data connections are supported (PivotTables) other data connection features are not yet supported this release (external data ranges/Query tables).

  Here are a couple of workarounds (short of just deleting the table entirely):

  http://blogs.msdn.com/luisbeonservices/archive/2006/12/11/using-udfs-and-excel-formulas-to-get-a-query-table-on-excel-services.aspx  (for using UDFs to workaround this)

  http://blogs.msdn.com/cumgranosalis/archive/2006/11/27/another-tool-for-working-around-excel-services-not-supporting-querytable.aspx  (for an Add-in that converts your Query Tables to PivotTables which are supported)

   

  
  
  
• Application crashed if i set the data source of excel to "external data connections"