Pivot Table - Thre are too many records to complete this opearation

%3CLINGO-SUB%20id%3D%22lingo-sub-1551453%22%20slang%3D%22en-US%22%3EPivot%20Table%20-%20Thre%20are%20too%20many%20records%20to%20complete%20this%20opearation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551453%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI%20am%20having%20an%20issue%20while%20creating%20a%20calculated%20item%20in%20Pivot%20Table%20I%20am%20getting%20an%20error%20message-%20Thre%20are%20too%20many%20records%20to%20complete%20this%20opearation.%20My%20excel%20sheet%20has%2014000%20rows%20of%20data.%20How%20to%20resolve%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1551453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1551477%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20-%20Thre%20are%20too%20many%20records%20to%20complete%20this%20opearation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383159%22%20target%3D%22_blank%22%3E%40Amruthamohan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESuch%20error%20could%20be%20with%20just%2010%20rows%20of%20data.%20Quite%20many%20reasons%2C%20there%20is%20no%20one%20abstract%20solution%20for%20all%20variants.%20Please%20google%20%22pivot%20table%20there%20are%20too%20many%20records%20to%20complete%20this%20operation%22%20to%20see%20for%20options%20and%20concrete%20case%20which%20is%20more%20close%20to%20your%20one.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
Hi,
I am having an issue while creating a calculated item in Pivot Table I am getting an error message- Thre are too many records to complete this opearation. My excel sheet has 14000 rows of data. How to resolve?
1 Reply

@Amruthamohan 

Such error could be with just 10 rows of data. Quite many reasons, there is no one abstract solution for all variants. Please google "pivot table there are too many records to complete this operation" to see for options and concrete case which is more close to your one.