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
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