Hi,

I am having a similar problem. The difference is that I have two worksheets
because the data entirely filled the first one and then spilled over into a
second worksheet. So there is too much data to consolidate into one
worksheet. I have tried the multiple consolidation route and just cannot get
any proper headings or data in my pivot table. I select all of the relevant
rows/columns in each worksheet and end up with a pivot table listing only
rows or columns etc. Any ideas for me?

"Roger Govier" wrote:

Hi

Trying to create PT's from data that resides on several sheets, requires you
to choose Multiple Consolidation ranges on the first screen of the dialogue.
The results from using Multiple Consolidation do not appear as you might
expect.

It would be better to aggregate all of the data from the individual BOM
sheets to one page of data, then Pivot that.
If you are still having difficulties, mail me a copy of the Workbook direct,
and I will see if I can see what is going wrong for you.
To mail direct
roger at technology4u dot co dot uk
Change the at and dots to make a valid email address.

--
Regards
Roger Govier

"Mwithc3" wrote in message
...
I am having trouble getting a pivot table to actually work. I have a
workbook divided into several worksheets. Each worksheet is a Bill of
Materials for a module. Each module, while being different is also made
up
of some common parts. I want to summarize the bills of material into a
summary sheet that can give me totals of all parts required for an entire
project.

Each worksheet is set up exactly the same, and the columns are named
fields
across the whole workbook. The fields are also formatted as text,
currency,
etc.

When I start the pivot table wizard, it skips steps and creates a table
that
I cannot do anything with. It also does not populate the field boxes with
the labels - they are just empty. I am wondering if this area of excel is
just corrupted in my installation.

Could really use some help. I checked out the link in another thread to
DataPig. Good info, but the wizard isn't even working right so I can't
even
go that far.