Home

Increased File Size

%3CLINGO-SUB%20id%3D%22lingo-sub-286992%22%20slang%3D%22en-US%22%3EIncreased%20File%20Size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286992%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%20I%20was%20working%20on%20an%20excel%20workbook%20that%20was%20originally%20only%2071kb%20in%20size%20and%20after%20editing%20several%20cells%2C%20the%20column%20for%20row%20numbers%20on%20the%20extreme%20left%20became%20wider%20and%20the%20file%20size%20increased%20to%20more%20than%202MB%2C%20which%20is%20weird%20since%20it's%20a%20simple%20spreadsheet.%20Anyone%20has%20this%20problem%20and%20knows%20what%20this%20is%20attributed%20to%3F%20I%20also%20tried%20using%20the%20Inquire%20add-in%20to%20remove%20excess%20cell%20formatting%20that%20could%20have%20happened%20but%20I%20get%20prompt%20saying%20that%20the%20default%20row%20size%20is%20zero%20and%20cannot%20be%20analyzed.%20Please%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-286992%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormatting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287046%22%20slang%3D%22en-US%22%3ERe%3A%20Increased%20File%20Size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287046%22%20slang%3D%22en-US%22%3Eactually%20it%20happened%20to%20me%20sometime%20ago%20and%20that's%20what%20I%20did.%20But%20really%20didn't%20know%20the%20reason.%20Maybe%20inadvertently%20some%20formats%20were%20added....%3CBR%20%2F%3Eglad%20that%20it%20helped..%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287042%22%20slang%3D%22en-US%22%3ERe%3A%20Increased%20File%20Size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287042%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Lorenzo.%20Would%20you%20know%20what%20might%20cause%20that%20to%20happen%20though%3F%20So%20that%20I%20can%20prevent%20it%20in%20future%2C%20rather%20than%20copy%20pasting%20every%20time%20it%20happens.%20Thanks%20mate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287033%22%20slang%3D%22en-US%22%3ERe%3A%20Increased%20File%20Size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287033%22%20slang%3D%22en-US%22%3Ecopy%20your%20data%20to%20another%20sheet%20or%20workbook.%3CBR%20%2F%3Ethen%20%22Clear%20All%22%20-%20after%20that%2C%20re-copy%20back%20the%20file.%3CBR%20%2F%3Esee%20what%20happens..%3CBR%20%2F%3Eremember%20to%20make%20a%20backup%20copy%20of%20your%20original%20work.%3CBR%20%2F%3EHTH%3C%2FLINGO-BODY%3E
Jason Ong
New Contributor

Hi guys, I was working on an excel workbook that was originally only 71kb in size and after editing several cells, the column for row numbers on the extreme left became wider and the file size increased to more than 2MB, which is weird since it's a simple spreadsheet. Anyone has this problem and knows what this is attributed to? I also tried using the Inquire add-in to remove excess cell formatting that could have happened but I get prompt saying that the default row size is zero and cannot be analyzed. Please help!

3 Replies
copy your data to another sheet or workbook.
then "Clear All" - after that, re-copy back the file.
see what happens..
remember to make a backup copy of your original work.
HTH

Thanks Lorenzo. Would you know what might cause that to happen though? So that I can prevent it in future, rather than copy pasting every time it happens. Thanks mate.

actually it happened to me sometime ago and that's what I did. But really didn't know the reason. Maybe inadvertently some formats were added....
glad that it helped..
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies