-
Sleeper: Working with more than 65000 rows and Pivot Tables
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
Hope you can help
Phil
-
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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules