SAP Knowledge Base Article - Preview

1332268 - VLOOKUP and other similar MS Excel funcations do not work when using xls files generated by Web Intelligence or Desktop Intelligence

Symptom

  • It is not possible to search on Excel files generated by Web Intelligence or Desktop Intelligence XI using Excel functions such as VLOOKUP
  • Using Excel functions such as VLOOKUP, '#N/A' is displayed when based on xls files created by WebI or DeskI


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI 3.0 ; SAP BusinessObjects Enterprise XI 3.1

Keywords

KBA , BI-RA-WBI , Web Intelligence , 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.