Error message - PivotTable will not fit on sheet. Show as much as

[Donna W]

Main sheet is 10 columns and 3696 rows. when creating pivot table get error
message. What can i do to get full spread sheet to load? the rows contain
names,
names go up to starting with Z but only load rows that go up to S.

 

[Roger Govier]

Hi Donna

What is the error message?
What is the range that you are giving to the Pivot Table?

 

[ilia]

Doesn't sound like it should be a problem, the error message might be
referring to something else.

Look at this article:
http://support.microsoft.com/kb/q211517/