View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve S Steve S is offline
external usenet poster
 
Posts: 4
Default Multiple Consolidation Ranges in pivot tables

I have a workbook with two sheets of about 40,000 rows each, when I try to
use the Multiple Consolidation Ranges option I don't see what is expected in
the field list ie. a list of the column/row names. Instead I get "row column
value".