Too much data in my spreadsheet

[SaraEX]

Although we have fairly sophisticated Excel ODBC reporting from the SQL tables of our ERP system, we are running into instability because of the amount of data we are bringing in for analysis. The spreadsheets are huge and get bogged down.

Can A pivot table utilize data that is not actually within the workbook? Can it query the underlying tables and just present the data pivot in the spreadsheet?

If not, what kind of tool am I looking for here?

 

[Hui]

SaraEX

Firstly, Welcome to the Chandoo.org Forums

Pivot Tables can access external data sources
Goto Insert, Pivot table and select External Data Source

Or you may want to look at using Power Pivot
http://chandoo.org/wp/2013/01/21/introduction-to-power-pivot/
http://chandoo.org/wp/search/?q=power pivot

 

[SaraEX]

Power Pivot looks like the trick. Thanks for pointing me in the right direction.