Pivot Table Snafu

  • Thread starter Thread starter Michael Allenbaugh
  • Start date Start date
M

Michael Allenbaugh

I am a budding Pivot Table enthusiast and I have come up
against a rather anoying problem that I just can't seem
to work around. I sometimes get the following error
message when creating a pivot table layout: "Microsoft
Excel cannot make this change because there are too many
row or column items. Drag at least one row or column
item off the pivot table, or to the page position.
Alternately, right click a field and then click Hide or
Hide Levels on the Shorcut Menu." Ok...sounds simple, I
have too many rows or columns. The problem is, I just
created another identical pivot table from an identical
datasource where Excel allowed me to create my desired
number of columns. This has happened to me on several
different occasions where, when using virtually identical
data and creating virtually identical pivot tables,
sometimes I can create the columns I want and sometimes I
can't.

I'm curious to find out if this is a common occurance. I
am also wondering if there is a way to increase the
number of columns that I can create in a pivot table.
Typically, I need to extract sales contact information
from a rather large database. The columns that I would
like to see would be something along the lines of Name,
Company Name, Address (one or two columns), City, State,
Zip, County, etc.

Thanks for any help someone may be able to provide. If
you need more info from me, please feel free to email
your questions.
 
I also came thru the same problem while using the pivot table for the
large sheet but creating another identical pivot table from an
identical
datasource could not solved my problem. I have tried microsofts
database for solution but in vain. It says that excel has some limit
on the nos of item due to which we are getting this problem. Please
let me know if you get any solution.

Regards,
 
Back
Top