Excel 2007 - Pivot Table Limitations?

J

JSpence2003

Is there a limit to the number of rows for a Pivot table to function properly?

When I get data that has at least 50k rows, my pivot tables hang up and/or
Freeze Excel. I know that is a lot of data, but not sure why it would freeze
excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot using 250,000 rows of data in Excel? 1
How can I change the source data reference to another pivot table? 2
Pivot Table Refresh not working properly 1
Pivot tables - memory issues - please help 2
Column limit for Pivot Table data source 1
Adding to an existing Pivot Table 7
Pivot table column limits 2

Top