I have a spreadsheet with two tabs of data. 63,000 rows on the first tab and 28,000 on the second tab due to the Excel 2003 data row constraints. When I try to create a pivot table using multiple sources of data I get an error saying it is too much data to be processed. Is there any workaround to this? Also, I have 12 columns of data on each sheet, each cell with less than ten words. Data is sensitive so I cannot attach.
Thanks.
Hi willy91785,
The easy answer is to upgrade to a newer version of Excel and all is good. Pivot tables work best if all the data is together. When it is spread on different sheets you need to use consolidate ranges that reduces the abilities of Pivot Tables.
If you deal with a lot of data that changes or grows there is a new Add-In from Microsoft called PowerPivots that was ment for large and unconnected datasets. Learn about it at: http://www.powerpivot.com/http://www.powerpivot.com/
Excel will deal with your problem but with a newer version.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks