Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table-Using Multiple SS's or Ranges?
I'm familiar with creating and editing Pivot Tables using
one worksheet. I would like to create a Pivot Table using different worksheets. The structure of all the lists are the same: same Header Row in each list. I'm going through the procedure and it is producing a Pivot Table but it is quite different from the Pivot Table Layouts that I'm used to seeing. When I go into the Layout Dialog Box, I'm not seeing the Field Names that one normally sees. 1) Am I doing something wrong? 2) Is this the way it works when you create a Pivot Table from multiple sources? 3) Should I just put all the data in one worksheet list and them produce the Pivot Table? Any assistance would be greatly appreciated as this is frustrating me mucho. Thanks! Jugglertwo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |