View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vakani Vakani is offline
external usenet poster
 
Posts: 1
Default 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?