filesize

  1. D

    Excel Worksheets containing 1048576 rows -

    Is there a vba macro that will delete all empty rows of a worksheet? I'm seeing my workbook sizes growing exponentially but when looking at the rows/columns that contain data, it showing the last row 2500, last column G. I wouldn't think that the workbook size should contain 1048576 rows and...
  2. JARHTMD

    How to list all Path, Filenames & Filesizes

    I have some coding (from http://www.mrexcel.com/forum/excel-questions/471508-list-properties-all-files-folder.html ) to get filesize. Public Function FileSize() Dim FSO As Object Set FSO = CreateObject("scripting.filesystemobject") FileSize = FSO.FileSize("C:\Windows\Windows.exe") End Function...
  3. S

    file size way too large

    I have a 2010 Excel file with three tabs, one that only has any data on it... and it only has 26 rows and 34 columns that have any data??? the file size is 5.2MB??? same file saved as 97-2003 is more than half the file size smaller at 2.1MB??? Can anyone help! Thanks, Sybo2
  4. A

    VLOOKUP across SharePoint 2007

    I am using an excel 2007 workbook as a basic form that returns lookup data from another workbook. Both files reside in sharepoint 2007 document libraries. I'm using a simple VLOOKUP function and the values are being returned just fine - my problem is that including these formulae makes the...
  5. C

    Massive 300MB Spreadsheet why?

    Hi, I've been given a 300MB spreadsheet and asked why is it so large? Where do I start? Any help would be appreciated.

Watch MrExcel Video

This Week's Hot Topics

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