Excel- Unresponsive when using pivot table with large raw data

%3CLINGO-SUB%20id%3D%22lingo-sub-320042%22%20slang%3D%22en-US%22%3EExcel-%20Unresponsive%20when%20using%20pivot%20table%20with%20large%20raw%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320042%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Team%2C%3CBR%20%2F%3EI%20have%20a%20pivot%20table%20created%20from%20a%20file%20of%20400K%20rows.%20Whenever%20any%20action%20is%20performed%20in%20the%20pivot%2C%20excel%20stops%20responding.%20I%20have%20tried%20with%20the%2064bit%20version%20also.%20I%20wanted%20to%20know%20if%20there%20is%20any%20size%20limitation%20to%20the%20pivot%20table%20and%20if%20so%2C%20what%20can%20be%20the%20alternate%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320042%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320062%22%20slang%3D%22en-US%22%3ERe%3A%20Excel-%20Unresponsive%20when%20using%20pivot%20table%20with%20large%20raw%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320062%22%20slang%3D%22en-US%22%3EHi%20Adam%2C%3CBR%20%2F%3EWill%20do.%20thank%20you.%3CBR%20%2F%3E%3CBR%20%2F%3ERohan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320046%22%20slang%3D%22en-US%22%3ERe%3A%20Excel-%20Unresponsive%20when%20using%20pivot%20table%20with%20large%20raw%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320046%22%20slang%3D%22en-US%22%3EHi!%20Please%20also%20post%20this%20in%20the%20excel%20forum%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E
New Contributor

Hi Team,
I have a pivot table created from a file of 400K rows. Whenever any action is performed in the pivot, excel stops responding. I have tried with the 64bit version also. I wanted to know if there is any size limitation to the pivot table and if so, what can be the alternate?

2 Replies
Highlighted
Hi! Please also post this in the excel forum :)

Adam
Highlighted
Hi Adam,
Will do. thank you.

Rohan