file size reduction

  1. S

    Is there an alternate way to look into an excel sheet instead of connections and queries?

    I have 2 workbooks. One is a Bill of materials (Bom) and the other is a master list (Ml). My bom takes the Ml as a connection, manipulates the data through power query and spits in on a new worksheet in the Bom workbook. I then open a new sheet (within the bom workbook) perform a vlookup and...
    • SPS41
    • Thread
    • excel excel macro file size reduction query & connections
    • Replies: 6
    • Forum: Excel Questions
  2. S

    Ascertaining Tab Size

    Was wondering if you geniuses could help me, I have a 41MB file that doesnt have any array formulas or huge tabs in it (although there are a lot of tabs), I have done the basic deleting contents of unused cells but the file size doesnt change. Is there any way to check via code or other on the...
  3. D

    Removing blank/empty rows

    I have a workbook that contains several different sheets of data. Two sheets, in particular, occasionally end up being unnecessarily long at the bottom/end of the sheet. There are many instances where the blank rows extend well beyond the data. This has increased my file size dramatically...

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