• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to put my Excel spreadsheet on a diet.

Eloise T

Active Member
I have a spreadsheet with just over 20 tabs. Each tab represents, by name, a different salesman for the company. Each week I'm emailed the sales for each salesman via their Excel spreadsheet which gets appended to the respective salesman's tab. Currently, the spreadsheet exceeds 6Mb. Last week, for concealment, I moved about 20 cells of data to the bottom of one of the tabs (Cells: A1045874 to J1048576) so that only I knew where it was. When I saved the file, I happened to check the file size. It had grown to over 38Mb. That was a problem I couldn't live with so I cut and pasted the 20 cells of data from Cells A1045874 to J1048576 to the bottom of the current data (Cell: A2500) and checked the file size...38Mb. My next attempt to eliminate the file fat, I highlighted from A2501 to J1048576 and used HOME > Editing > Clear. Checked the file size....STILL at 38Mb! Not until I recreated the tab and copied and pasted ONLY the current data A1 to J2500 did the file size go back to 6Mb. Anyone know of a better/quicker/more timelier way to eliminate the file fat in this case?
 

Peter Bartholomew

Well-Known Member
I tend to select entire rows and extend using ctrl/+shift+down arrow, and then delete sheet rows. The Used Range only adjusts following a Save and Load cycle and, even then, there appear to be no guaranties.

Maybe a hidden sheet would serve you better next time you wish to move data out of sight.
 

GraH - Guido

Well-Known Member
I go with, for each sheet:
- Find the last cell (CTRL+END)
- Select all columns from end of data until this last cell and delete those columns
- Same for the rows
Save.

Along the same road as @pecoflyer's idea, keep data external and create a single pivot where data can be filtered by user. I would be surprised such workbook exceeds 6 MB.
 

Eloise T

Active Member
I go with, for each sheet:
- Find the last cell (CTRL+END)
- Select all columns from end of data until this last cell and delete those columns
- Same for the rows
Save.

Along the same road as @pecoflyer's idea, keep data external and create a single pivot where data can be filtered by user. I would be surprised such workbook exceeds 6 MB.
Thank you for your suggestion and clarification. I will look into that as well. Thanks.
 
Top