1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Windows Excel file sizes....

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

  1. jopers1986

    jopers1986 Member

    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 New Member

    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 Member

    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