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
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....