Windows Excel file sizes....

Discussion in 'Software' started by jopers1986, 22 Jul 2009.

  1. jopers1986

    jopers1986 Minimodder

    Joined:
    7 Jan 2005
    Posts:
    559
    Likes Received:
    4
    Right i have 3 spreadsheets at work, they are all pretty much the same, just containing different figures, a few macros etc.

    however, 2 are around 700kb but the third is 12mb.... why could this be?

    thanks
     
    jopers1986, 22 Jul 2009
    #1
  2. steveo_mcg

    steveo_mcg What's a Dremel?

    Joined:
    26 May 2005
    Posts:
    5,841
    Likes Received:
    80
    Does the third have conditional formatting on?
     
    steveo_mcg, 22 Jul 2009
    #2
  3. jopers1986

    jopers1986 Minimodder

    Joined:
    7 Jan 2005
    Posts:
    559
    Likes Received:
    4
    They all have conditional formatting, there must have been somthing hidden in the sheet, as i selected all the cells that didn't contain something useful and cleared the data and formatting, and the file went from 12mb to 400kb....
     
    jopers1986, 22 Jul 2009
    #3

Share This Page