Excel - There are too many records to complete this operation

In Excel I was working with a pivot table. The following message popped up:
"There are too many records to complete this operation."

Solution
Click Analyze (or Options in Excel 2010)
Click Fields, Items & Sets
Click Solve Order

If you have something listed, it is probably causing the problem. Delete it, then try working with your pivot table again, all should be well.



NOTE: I've tested this with Excel 2013 but it should work the same way with other versions.