Pivot report will not fit on sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table with data in columns a to AC. When I try to add another
column of data for January 2007 I get a message "Pivot report will not fit on
sheet. Do you want to show as much as possible?"
What does this mean? The columns are results by month for data from 2004 to
Dec 2006.
Any help appreciated!
Thanks,
Dan
 
I think I found the problem. Each Record has a date, which is grouped by year
and month in the pivot table. One of the 16,655 records had a missing date
and when I corrected it, the table displayed just fine.
Oh, the nitty-gritty of it all!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Duplicate January 2
Pivot Table Variance 2
Pivot Table 1
Pivot from all sheets 1
Referencing a pivot tables Grand Totals Column 1
Pivot table not recognizing same field values 1
Pivot report 1
One pivot table cannot overlap another pivot issue. 1

Back
Top