SAP Knowledge Base Article - Preview

1400626 - Live Office refresh changes Excel formula references

Symptom

During a Live Office refresh, the data returned contains fewer rows of data than what was originally mapped on the spreadsheet.  As a result, the last row(s) that once contained data, are now blank.  If an Excel function referenced any of those cells, the result now returns #REF or #N/A.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

Excel references; Excel functions; formula changes; Live Office refresh , KBA , BI-RA , Reporting, analysis, and dashboards , 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.