reduce file size

  1. A

    VBA code to delete formula if result = zero

    I'm trying to reduce an Excel 2010 file in size by clearing the contents of cells where a formula has returned a zero value. I have found this VBA script which does the job but not very well for the data set I'm working with: Sub delzero() For Each Cell In [W12:BF24459] If Cell.Value = "0" Then...
    • asyouread
    • Thread
    • clear contents in vba large data set reduce file size vba & excel 2010
    • Replies: 14
    • Forum: Excel Questions
  2. M

    File size does not reduce when breaking links

    Hi all I have a "report" xlsx file which links to a "data" xlsx file as a data source. The links are just normal cell reference links and a few SUMIFS with no macros. The file size of the report file is around 4.5MB. Once I have refreshed the data by having the two files open together, I close...

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
Back
Top