I had an opportunity to test out one of the participant’s data comprising 500,000 (half a million) rows using PowerPivot with my computer which is running a 2 year old i5 chip with 6GB ram. The data failed to load into PowerPivot because of insufficient memory. The data source is an Excel file.

Leave a Reply