Providing a direct, secure link from Microsoft Excel to corporate data presents a significant challenge. This paper describes how to leverage WebFOCUS business intelligence software to generate Excel spreadsheets directly from enterprise data sources, consolidating large amounts of data, performing complex calculations, and creating advanced structures like PivotTables.

This limits an organization's exposure to costly errors and fraud, while allowing analysts and other end users to perform detailed analysis in their tool of choice with no learning curve.