Hi Susan

there is a method, where you can load much larger files than 65536 rows into
the Pivot cache.
I can't look out the answer for you right now, but will post gain in the
morning.

--
Regards
Roger Govier

"Susan" wrote in message
...
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.