How do I compress small Workbook which shows 30 MB in size?
 

I am using Excel 2003. Somehow a small (approx 60KB) file's apparent size got
expanded to 30MB. I can recopy worksheet to new workbook and recover small
size. I would like to know if there is a method of accomplishing this
recovery or "recompression" without copying to a new workbook.

Debra Dalgleish has some techniques to reset that last used cell of a worksheet
at:

http://www.contextures.com/xlfaqApp.html#Unused

But 30 meg is pretty big. Any chance you've added pictures/background to the
worksheet?

netgd wrote:

I am using Excel 2003. Somehow a small (approx 60KB) file's apparent size got
expanded to 30MB. I can recopy worksheet to new workbook and recover small
size. I would like to know if there is a method of accomplishing this
recovery or "recompression" without copying to a new workbook.

--

Dave Peterson