"rossij8" wrote in
message ...

I work with a Excel Spreadsheet on a daily basis - it contains basic
formulas and sums. Over the last couple of months it has been gradually
growing (not physically as it generally stays the same size)

It got to 19.4 mb in size whem really it should be around 500kb

We cant work out why it has done this and where it is storing this
extra information

It has basically become unusable as it is so slow

Anyone have any ideas?

James

One of the most common reasons for a major increase in file size is that the
last used cell of a worksheet (or maybe more than one!) is way beyond what
you think you are using. The last used cell is at the intersection of the
highest row and the highest column that have 'anything' in them. 'Anything'
in this case can even be a single space character (that you obviously can't
see), or any kind of formatting. To get to the last used cell use CTRL+END.
If this is beyond where you expect, simply delete rows, and then columns,
between where you expect and the last used cell. Save the file (and in some
early versions of Excel close the program and restart). Does this cure the
problem?