PremSivakanthan
New Member
Hi, I've got a workbook with about 6 worksheets, and it is about 3.5MB in size. I'm trying to reduce its size, as it is something that will be emailed out regularly.
I've done a bit of research online, and have tried all of the usual tricks (all formulas pasted as values, go to last row/column and delete everything past that point to make sure there is no 'phantom' data, reduced formatting etc), but this does not reduce the size very much.
I've narrowed down the offending worksheets 3x worksheets that have all of the source data in it, they are about 1MB each, and they use about 180,000 cells, and they are all values (no formulas).
My question is: for one worksheet that is using about 180,000 cells, is 1MB to big??
I've done a bit of research online, and have tried all of the usual tricks (all formulas pasted as values, go to last row/column and delete everything past that point to make sure there is no 'phantom' data, reduced formatting etc), but this does not reduce the size very much.
I've narrowed down the offending worksheets 3x worksheets that have all of the source data in it, they are about 1MB each, and they use about 180,000 cells, and they are all values (no formulas).
My question is: for one worksheet that is using about 180,000 cells, is 1MB to big??