SAP Knowledge Base Article - Preview

2051995 - "Error: Unable to create or update the Excel personal data provider: the range selection is invalid. (WIS 10885)" when using Excel as data provider in Web Intelligence report

Symptom

  • A Web Intelligence (WebI) report uses a Microsoft Excel spreadsheet as the data source
  • After selecting the XLS file to be used as the report's data source and clicking "Next >>", the following error appears:

    "Unable to create or update the Excel personal data provider: the range selection is invalid. (WIS 10885)"


Read more...

Environment

  • SAP BusinessObjects Enterprise XI 3.1
  • Microsoft Excel

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

BOE BI BI3 XI3 XI31 BOE31 BOE3.1 XI3.1 enterprise server busobj business objects InfoView ePortfolio WebIntelligence webi interactive analysis unsupported feature select selection choice choose pick listbox list box combobox combo dropdown drop down picklist menu ms microsoft msexcel msoffice office suite xls xlsx .xls .xlsx sheet workbook worksheet , KBA , BI-RA-WBI-FE , Front End/Client , BI-RA-WBI , Web Intelligence , BI-RA-WBI-BE , Back End/Server , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.