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...

    How to list all Path, Filenames & Filesizes

    I have some coding (from ) 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.

Some videos you may like

This Week's Hot Topics