Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 256
Default 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 -



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message in my Excel sheet ub Excel Worksheet Functions 2 May 29th 07 08:45 PM
Error message when creating PivotTable Alexandre Excel Discussion (Misc queries) 1 November 27th 06 10:06 AM
copy sheet error message brucearthurhall New Users to Excel 1 March 21st 06 01:18 PM
Error message with protected sheet HRman Excel Discussion (Misc queries) 1 November 28th 05 06:59 PM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. Tim Marsden Charts and Charting in Excel 2 October 15th 05 02:10 PM


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"