Worksheet size is causing a save issue

Swaroon

Active Member
Joined
Nov 18, 2005
Messages
281
Hi,
I have a workbook with multiple sheets, I ran a macro I found on this site which gives me the size of each tab, per the macro, the 20 tabs add to cc 3.7kb, on saving the file, the file size showing is 30kb.

I would have expected to see one or two tabs with large sizes, usually to do with embedded formatting, clear the rows and save, and the file size reduces, there's no large tabs per the macro result to clear.

The macro within the file is not the most efficiently written but does the job, a lot of .Select statements, the file seems to increase in size after each run and save, any ideas on how to reduce the file size, it's a bit like clearing the cache scenario ?

thanks
Steve
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,908
Office Version
  1. 365
Platform
  1. Windows
the file size showing is 30kb.
If anything, I would have said that the file size looks too small. I would expect more than that for a single sheet unless it is almost empty. Very few people would be likely to notice such a minor increase in file size. Unless malicious activity was suspected, I wouldn't even bother investigating the cause.

The code that checks the sheet size might not account for everything. It will be unlikely to include things like the vba project (your macros), the data model (pivot tables) or other similar objects.
 

Swaroon

Active Member
Joined
Nov 18, 2005
Messages
281
If anything, I would have said that the file size looks too small. I would expect more than that for a single sheet unless it is almost empty. Very few people would be likely to notice such a minor increase in file size. Unless malicious activity was suspected, I wouldn't even bother investigating the cause.

The code that checks the sheet size might not account for everything. It will be unlikely to include things like the vba project (your macros), the data model (pivot tables) or other similar objects.


Hi Jason,

Thanks for the reply, some misinformation on my part, I meant :

Macro shows all tabs add to 4,000kb, and the file saved properties show as 28,879kb

No pivots so maybe it's the vba project as you suggest.

thanks
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
13,908
Office Version
  1. 365
Platform
  1. Windows
That's quite a significant difference compared to what you said earlier. The vba project wouldn't take up that much space.

Best guess without a lot more information would be bloat from inefficient practice / code. There are a number of causes, the biggest being changes to the unused part of the sheet. It might appear empty, but that doesn't mean that it is.

Take a look at the thread that I've linked below, particularly post 7. If you search the forum for 'bloat' or google for 'excel bloat' then you will find many possible causes and suggestions of how to rectify the problems.

 

Swaroon

Active Member
Joined
Nov 18, 2005
Messages
281
That's quite a significant difference compared to what you said earlier. The vba project wouldn't take up that much space.

Best guess without a lot more information would be bloat from inefficient practice / code. There are a number of causes, the biggest being changes to the unused part of the sheet. It might appear empty, but that doesn't mean that it is.

Take a look at the thread that I've linked below, particularly post 7. If you search the forum for 'bloat' or google for 'excel bloat' then you will find many possible causes and suggestions of how to rectify the problems.



Great, appreciate the help, will check them out.
 

Forum statistics

Threads
1,144,370
Messages
5,723,959
Members
422,529
Latest member
mbilal429

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top