LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
dmotika
 
Posts: n/a
Default Pivot Table - max rows allowed in data range

Hi! What is the maximum rows allowed in a data range when using a pivot table?

I have a pivot table that uses a data range. When I have only 4581 records
in the data range, the pivot table updates with no problems. But, when
entering more than 4581, the pivot table won't update and gives me an error.

Am I hitting the max on data rows within my data range or is there a
work-around.

Thanks!!

dmotika

 
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
Combining Pivot Tables - Summarising data from 100,000 rows Alan Excel Discussion (Misc queries) 1 May 18th 05 10:09 PM
Pivot Table for survey results with set of possible answers in PT's Rows Field? [email protected] Excel Discussion (Misc queries) 0 May 16th 05 10:35 PM
Pivot table - printing specific data Doug Excel Discussion (Misc queries) 1 April 24th 05 08:29 PM
Do Pivot Tables have an automatic data range expansion? David.c.h Excel Discussion (Misc queries) 1 March 26th 05 12:55 AM
Pivot Table Data Spencer Hutton Excel Worksheet Functions 2 March 2nd 05 06:45 PM


All times are GMT +1. The time now is 10:09 PM.

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"