Pivot table limits

N

neilamor

I get error message "there are too many records to vcomplete this operation"
when refreshing certain Pivot tables in a worksheet.

Other Pivot tables in the same sheet, based upon the same range of records
refresh OK

What is wrong?
 
D

Don S

I get error message "there are too many records to vcomplete this operation"
when refreshing certain Pivot tables in a worksheet.

Other Pivot tables in the same sheet, based upon the same range of records
refresh OK

What is wrong?
Click to expand...

You may be selecting a data field as a column in your pivot table that
has more entries than Excel has rows. Try changing how you are laying
out the table.

Don S
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot table grouping help 0
Pivot table report invalid 0
Excel does not accept text format! 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Retain pivot table formatting after refreshing data 0
Excel 2013 Pivot Data Range formula reference problem 0
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1

Top