Excel - Pivot tables?

bloodline76

bloodline76

bloodline76

Soldato
Joined
7 Feb 2004
Posts
9,511
Anyone know much about pivot tables when using MS Excel 2007? When are trying to do a pivot table for a data report on security event errors.

The problem we are getting is that there are over 500,000 lines of data and when we try and put them into a pivot table it crashes as our computers cant handle that amount of data.

Is it a RAM issue?

We have dual core processor laptops with 2 gigs of ram.

Or anyone else recommend a good way of displaying data that is easily readable for clients to understand.

Thanks
 
Try sticking the data into an Access table and running a pivot table from that. Access tends to handle large data tables far better than Excel.

Also make sure your Excel workbook is an .xlsx file and not just .xls.

Option three: separate the data into different workbooks (if you can).

Option four: buy more RAM and see if that helps.

Option five: close all other progams.
 
You must log in or register to reply here.
Back
Top Bottom