Home

Unresponsive when using pivot table with large raw data

%3CLINGO-SUB%20id%3D%22lingo-sub-320063%22%20slang%3D%22en-US%22%3EUnresponsive%20when%20using%20pivot%20table%20with%20large%20raw%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20Team%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%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%20solution%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERohan%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-320063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
rohanraj
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 solution?

 

Rohan

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies