LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Maximum Size Pivot Table

I have a pivot table set up, reporting on a data table made up of almost
12,000 rows of data. The pivot table has been working fine.

Today I added more data to the data table, now bringing it to 11,990 rows.
However, my Pivot table does pick up data below row 11,923.

I have checked the range for the data in the pivot table and it is set to
pick up data down to row 20,000.

Is there a maximum number of rows of data that you can analyse with a pivot
table or is there another possible reason for this problem ?

Any help, much appreciated.
Simon
 
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
Pivot Table Size PCStechnical Charts and Charting in Excel 0 October 12th 06 06:25 PM
Auto size a pivot table to a page size *.* Excel Worksheet Functions 1 August 23rd 06 05:09 AM
Why size of email with pivot table is so big? Angus Excel Discussion (Misc queries) 0 July 30th 05 04:52 AM
Pivot table - size of file? carolyn Excel Discussion (Misc queries) 1 June 17th 05 05:58 PM
maximum size of a Microsoft Excel list for a pivot table Bob Carey Excel Discussion (Misc queries) 1 January 6th 05 04:50 PM


All times are GMT +1. The time now is 11:00 AM.

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

About Us

"It's about Microsoft Excel"