Differences between Excel Pivot Tables

September 4, 2009 9:31 AM

Why is the functionality of an Excel Pivot table different depending on whether you use a list or a multiple consolidation range?

This is driving me crazy.

I have an Excel Workbook containing 6 worksheets. When I create a pivot table from a list, I can drag the field buttons onto my table and create a pretty nice report. When I try the same thing using a multiple consolidation range (data from various sheets), I only have 4 field buttons: Row, Column, Value and Page1. All my sheets have identical column headings.

Is this by design?

Thanks.

posted by DZ-015 to computers & internet (1 comment total)

It appears to be a limitation of consolidated data ranges.
posted by dfriedman at 9:55 AM on September 4