ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Error message - PivotTable will not fit on sheet. Show as much as (https://www.excelbanter.com/excel-worksheet-functions/147908-error-message-pivottable-will-not-fit-sheet-show-much.html)

Donna W

Error message - PivotTable will not fit on sheet. Show as much as
 
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

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

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

--
Regards

Roger Govier


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




ilia

Error message - PivotTable will not fit on sheet. Show as much as
 
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/


On Jun 25, 5:31 pm, "Roger Govier"
wrote:
Hi Donna

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

--
Regards

Roger Govier

"Donna W" <Donna wrote in ...



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.- Hide quoted text -


- Show quoted text -





All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com