Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2009
    Location
    White Plains, NY, USA
    Posts
    45
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Excel File Growing Beyond Belief

    I am a desktop tech at a municipal agency with what i thought was great skill in Excel.User gave me a spreadsheet with about 50,000 rows, 20 columns on one page, pivot table on another. She needed just about 150 rows left, delete the rest.I do it, but file that started out as 16 MB, doubles. I then start deleting the empty rows, file still grows, now I have 20000 rows and file is almost 200 MB.I delete data from 1st page, save file. Still huge. Also, this was originally a netork file, but even locally, I cannot change the file sharing.Why is file growing when it should be shrinking. I also confess to being ignorant on pivot tables.Help!!!!

  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Quote Originally Posted by wexmary View Post
    I am a desktop tech at a municipal agency with what i thought was great skill in Excel.User gave me a spreadsheet with about 50,000 rows, 20 columns on one page, pivot table on another. She needed just about 150 rows left, delete the rest.I do it, but file that started out as 16 MB, doubles. I then start deleting the empty rows, file still grows, now I have 20000 rows and file is almost 200 MB.I delete data from 1st page, save file. Still huge. Also, this was originally a netork file, but even locally, I cannot change the file sharing.Why is file growing when it should be shrinking. I also confess to being ignorant on pivot tables.Help!!!!
    Not sure if this will help, but if you right-click the Pivot Table and select Pivot Table options or Table Options (not sure which version of Excel you have), is there an option that says Save Data with File. If it's checked, uncheck it, save the file, open it again and try refreshing the Pivot Table and see if this helps. As always, take a backup copy of the file first.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Is it a Shared Workbook? If so, file bloat is one of the many common issues with shared workbooks.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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