PDA

View Full Version : Sleeper: Working with more than 65000 rows and Pivot Tables



philh06
02-11-2009, 03:21 PM
Hi all,

Wonder if you can help (a quick search on here didnt produce what I was looking for)

I hold a lot of data (currently in 2 worksheets due to volume and exceeding the limit of 65000 rows - the max limit for excel 03??) and I am finding Pivot Table analysis quite limited due to the fact that I am using 2 worksheets.

I would like (if possible) to analyse the data from one worksheet only, in other words, is there any way to increase the max. number of rows in a ny given worksheet

I have considered stripping some of the data to make the worksheet smaller but really need all the data to be able to analyse efficiently

I am also aware that excel 07 can handle more than a million rows but the company are not due to upgrade until later this yr :dunno

Hope you can help

Phil

mdmackillop
02-11-2009, 03:37 PM
You can't increase the number of rows in excel.
I've no experience of this but a pivot table can use an external data source. Possible you could store your data in Access and analyse it from there.