+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : File size has increased in size...Why

  1. #1
    THORmx
    Guest

    File size has increased in size...Why

    Hi,

    I am needing some serious help here. I'm a pilot and have created myself a logbook, as well as doing it for a few others.

    The Macro excel file has 4 sheets, 5 pivot tables, and like 62 columns of data (all with data validation), down to 496 rows inputted (on one sheet (sheet 2), the rest have a lot less data)

    It adds columns, up to row 10,000. The pivot tables take data from all 10,000 rows and such....file size is only 2.10MB

    The problem is, on one file, which should operate the EXACT same way, with only 3 sheets, 4 pivot tables, 64 columns (with data validation), and only 38 rows of data entered, and the file size IS 18.10MB!!!!!

    Where in the world, is the ADDITIONAL 16.00MB of data coming from????

    PLEASE HELP!
    Last edited by VBA Noob; 02-12-2009 at 04:17 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,005

    Re: Need help finding cause of file size 9x what it should be.

    Excel sometimes does that, it may be best just to copy and paste just the relevant data to a new workbook. Don't copy the entire sheets just the areas with data.

  3. #3
    THORmx
    Guest

    Re: Need help finding cause of file size 9x what it should be.

    That is very odd that it could do that. I will try what you suggest.

    Thanks

  4. #4
    THORmx
    Guest

    Re: Need help finding cause of file size 9x what it should be.

    Mod's, please mark solved.

    davesexcel thank you...it worked!

+ Reply to Thread

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