Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum number of rows in pivot table data
I have my sales data with number of rows exceeding sheet limit of 65536 so i
make another sheet and store data from Jan-Jun in one sheet and Jul-Dec on another sheet. Now if i want to make pivot report base on my full date how i give date range in pivot table? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum number of rows in pivot table data
You want to use multiple consolidation ranges...
http://www.contextures.com/xlPivot08.html -- HTH... Jim Thomlinson "Vakani" wrote: I have my sales data with number of rows exceeding sheet limit of 65536 so i make another sheet and store data from Jan-Jun in one sheet and Jul-Dec on another sheet. Now if i want to make pivot report base on my full date how i give date range in pivot table? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum number of rows in pivot table data
On her Contextures site, Debra Dalgleish has instructions on creating pivot
tables from multiple ranges: http://www.contextures.com/xlPivot08.html Or, if you used Excel 2007, you would have a million rows per sheet and could have a single (giant) range. Hope this helps, Hutch "Vakani" wrote: I have my sales data with number of rows exceeding sheet limit of 65536 so i make another sheet and store data from Jan-Jun in one sheet and Jul-Dec on another sheet. Now if i want to make pivot report base on my full date how i give date range in pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
maximum number of rows | Excel Discussion (Misc queries) | |||
Pivot table row fields limit vs. number of rows in use for Excel 2 | Excel Discussion (Misc queries) | |||
Increase the maximum number of rows | Excel Discussion (Misc queries) | |||
Maximum number of rows? | Excel Discussion (Misc queries) | |||
Maximum number of rows | Setting up and Configuration of Excel |