workbook file size too big when i try to add calculated item in pivot table need help

%3CLINGO-SUB%20id%3D%22lingo-sub-1541102%22%20slang%3D%22en-US%22%3Eworkbook%20file%20size%20too%20big%20when%20i%20try%20to%20add%20calculated%20item%20in%20pivot%20table%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541102%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20file%20size%20of%206MB%20and%20when%20i%20try%20to%20create%20Pivot%20table%20and%20add%20calculated%20items%20(subtract%20one%20pivot%20column%20with%20other%20column)%20it%20is%20getting%20hanged%20and%20not%20able%20create%20calculate%20item%20field.%20Need%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1541102%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1541156%22%20slang%3D%22en-US%22%3ERe%3A%20workbook%20file%20size%20too%20big%20when%20i%20try%20to%20add%20calculated%20item%20in%20pivot%20table%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541156%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%3CP%3EHow%20about%20importing%20the%20data%20from%20this%20file%20into%20a%20blank%20file%20through%20Power%20Query%20and%20add%20the%20data%20into%20the%20Data%20Model%20and%20create%20the%20Pivot%20Table%20either%20from%20Power%20Pivot%20Window%20or%20directly%20insert%20a%20Pivot%20Table%20through%20Power%20Query%20Editor%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547697%22%20slang%3D%22en-US%22%3ERe%3A%20workbook%20file%20size%20too%20big%20when%20i%20try%20to%20add%20calculated%20item%20in%20pivot%20table%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547697%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20this%20method%20suggested%20but%20now%20i%20am%20getting%20an%20error%20message%20as%20%22there%20are%20too%20many%20records%20to%20complete%20this%20operation%22%20and%20stuck%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548814%22%20slang%3D%22en-US%22%3ERe%3A%20workbook%20file%20size%20too%20big%20when%20i%20try%20to%20add%20calculated%20item%20in%20pivot%20table%20need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548814%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%3EI%20didn't%20see%20this%20error%20for%20a%20long%20while%2C%20but%20%22too%20many%20records..%22%20usually%20doesn't%20mean%20your%20file%20is%20big.%20Couple%20of%20discussions%20on%20first%20page%20of%20search%2C%20but%20that's%20much%20more%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmgxp.blogspot.com%2F2018%2F11%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmgxp.blogspot.com%2F2018%2F11%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fwhat-are-the-limits-of-excel-2010s-calculated-item%2F4f1513f5-5183-4328-a939-9ca79a19fc0d%3Fpage%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fwhat-are-the-limits-of-excel-2010s-calculated-item%2F4f1513f5-5183-4328-a939-9ca79a19fc0d%3Fpage%3D1%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20be%20other%20reasons%2C%20perhaps%20depends%20on%20Excel%20version%20as%20well.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a workbook file size of 6MB and when i try to create Pivot table and add calculated items (subtract one pivot column with other column) it is getting hanged and not able create calculate item field. Need help.

3 Replies

@Amruthamohan 

How about importing the data from this file into a blank file through Power Query and add the data into the Data Model and create the Pivot Table either from Power Pivot Window or directly insert a Pivot Table through Power Query Editor?

I tried this method suggested but now i am getting an error message as "there are too many records to complete this operation" and stuck here.

@Amruthamohan 

I didn't see this error for a long while, but "too many records.." usually doesn't mean your file is big. Couple of discussions on first page of search, but that's much more

https://mgxp.blogspot.com/2018/11/

https://answers.microsoft.com/en-us/msoffice/forum/all/what-are-the-limits-of-excel-2010s-calculated...

 

Could be other reasons, perhaps depends on Excel version as well.