Home

Excel file size

%3CLINGO-SUB%20id%3D%22lingo-sub-634865%22%20slang%3D%22en-US%22%3EExcel%20file%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-634865%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20with%20about%20200%20worksheets.%26nbsp%3B%20Each%20sheet%20contains%20data%20for%20a%20specific%20entity%2C%20but%20the%20data%20is%20basically%20the%20same%20information%20on%20each%20sheet.%26nbsp%3B%20When%20I%20replace%20the%20old%20data%20with%20new%20information%2C%20I%20create%20a%20temporary%20template%20sheet%2C%20work%20on%20that%2C%20then%20copy%20it%20over%20to%20the%20original%20sheet%20and%20delete%20the%20template.%26nbsp%3B%20This%20has%20worked%20for%20a%20long%20time%2C%20but%20recently%2C%20I've%20noticed%20that%20my%20file%20is%20growing%20exponentially%20even%20though%20the%20number%20of%20sheets%20and%20data%20is%20the%20same.%26nbsp%3B%20Anyone%20have%20this%20problem%20also.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-634865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-635678%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20size%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-635678%22%20slang%3D%22en-US%22%3EYou%20may%20have%20to%20reconstruct%20the%20structure%20of%20your%20data%20to%20result%20in%20only%201%20data%20sheet%20and%20only%201%20summary%20sheet.%20The%20latter%20shall%20pull%20data%20from%20the%20former%20based%20on%20specified%20parameters.%3C%2FLINGO-BODY%3E
susieinouye
Occasional Visitor

I have a workbook with about 200 worksheets.  Each sheet contains data for a specific entity, but the data is basically the same information on each sheet.  When I replace the old data with new information, I create a temporary template sheet, work on that, then copy it over to the original sheet and delete the template.  This has worked for a long time, but recently, I've noticed that my file is growing exponentially even though the number of sheets and data is the same.  Anyone have this problem also.

1 Reply
You may have to reconstruct the structure of your data to result in only 1 data sheet and only 1 summary sheet. The latter shall pull data from the former based on specified parameters.