Results 1 to 14 of 14

Saved file size not reduced to original

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2009
    Location
    Fareham,England
    MS-Off Ver
    Excel 2003
    Posts
    16

    Saved file size not reduced to original

    I have an Excell 2003 workbook with 6 worksheets and some VBA programmed macros in it. With a small amount of data the .xls file size is 150k. Then I tested it with a much larger sample of data, which goes into one of the worksheets, resulting size 3MB. Later on I reverted to reading in the original small amount of data but the file size stubbornly sticks to 400k instead of reverting to 150k.

    The old data is definitely not there anymore - I used this code to clear it:

      wsDATA.Range("A" & DATA_HEADING_ROWS + 1).CurrentRegion. _
    Offset(DATA_HEADING_ROWS, 0).ClearContents
    On further checking if I press ctrl + End it shows me a cell way down where the end of the old large data was. It seems I haven't cleared everything. Any suggestions as to how to clear it all?
    Last edited by rustleg; 04-26-2009 at 04:48 AM. Reason: More info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1