Error opening Excel file which contains a Pivot table that uses a "date between" filter in TIBCO Spotfire

Error opening Excel file which contains a Pivot table that uses a "date between" filter in TIBCO Spotfire

book

Article ID: KB0075057

calendar_today

Updated On:

Products Versions
Spotfire Analyst TS 10.9 HF-002 and lower, TS 10.3.3 HF-016 and lower
TIBCO Cloud Spotfire All

Description

When trying to load an Excel file in the TIBCO Spotfire installed client, the data may fail to load with an error message like the following, even when the Excel version is already Excel 97 or newer:

Error message: Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 or newer

AggregateException at :
One or more errors occurred. (HRESULT: 80131500)

Stack Trace:

Aggregated exception:

ImportException at Spotfire.Dxp.Data:
Failed to execute data source query for data source "<data source>". (HRESULT: 80131500)

Stack Trace:
at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<GetPromptRequests>d__7.MoveNext()
at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<EnumerateModels>d__6.MoveNext()

ImportException at Spotfire.Dxp.Data:
Requested value 'dateBetween' was not found. (HRESULT: 80131500)


 

Resolution

This issue is seen when the Excel file being imported contains a pivot table that uses a "date between" filter. Note: The error message about the unsupported version is misleading.

To resolve, upgrade your TIBCO Spotfire client as this has been fixed in:
  • TS 10.3.3 HF-017 and higher
  • TS 10.9.0 HF-002 and higher
  • TS 10.10 and higher

Issue/Introduction

Misleading error opening Excel file which contains a Pivot table that uses a "date between" filter in TIBCO Spotfire

Additional Information

Wiki: List of hotfixes for TIBCO Spotfire® Clients
Powered by Wolken Software