+ Reply to Thread
Results 1 to 2 of 2

Delete Columns; File Size Grows?

  1. #1
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    780

    Delete Columns; File Size Grows?

    I'm working to get a file size down, yet getting what I think is strange behavior.

    I have data spanning 50+ columns and over 5,000 rows. The file size is currently ~ 8.2MB.

    And in experimenting, when I delete about 7 of those columns (all with data in those 5000 rows) and resaving the file, the file actually grows in size to ~8.7MB. Why would it grow 500k when I'm actually deleting data?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,595

    Re: Delete Columns; File Size Grows?

    Do you have Conditional Formatting? If you do, check the rules and the ranges they apply to. You might find there are dozens of identical rules applied to subsets of the original range.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel table size grows as another table grows
    By JimDandy in forum Excel General
    Replies: 0
    Last Post: 03-08-2017, 04:25 AM
  2. File size grows when using Macro to copy/paste to new Workbook
    By JabeSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2014, 03:04 AM
  3. Replies: 0
    Last Post: 05-18-2011, 07:43 AM
  4. Excel file size grows when copied
    By EsAssistant in forum Excel General
    Replies: 2
    Last Post: 12-10-2010, 05:53 AM
  5. File size grows to unrealistic proportions
    By kevsvette in forum Excel General
    Replies: 1
    Last Post: 06-06-2007, 09:20 PM
  6. Shared Workbook inexplicably grows in size
    By Bob in forum Excel General
    Replies: 0
    Last Post: 08-18-2006, 08:35 AM
  7. Shared Workbook Grows Rapidly in Size
    By Burgerfield in forum Excel General
    Replies: 3
    Last Post: 04-12-2005, 05:06 AM

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