I have a pretty basic budget in an Excel File. It has some formatting and a
few formulas, but nothing extreme. Each month, I copy the sheet and reuse
it. ie - At the end of March, I copy March's sheet and rename it April, and
so on. So by the end of the year, I have 12 sheets. The first two sheets of
the year were very small and the file size was only about 1.5Mb. However,
all of a sudden, it's up to 9.5Mb. The last sheet that I copied added about
4Mb. I have no hidden sheets, have deleted all extra rows and columns. I
even tried removing all the formatting and it didn't change the file size at
all. When I Copy/Paste Special/Text Only into a new sheet, the file size
goes back to being very small. Any ideas why the file size keeps
skyrocketing?

Worth reading this article.
http://www.ozgrid.com/Excel/ExcelProblems.htm

If this post helps click Yes
---------------
Jacob Skaria


"JTS1974" wrote:

I have a pretty basic budget in an Excel File. It has some formatting and a
few formulas, but nothing extreme. Each month, I copy the sheet and reuse
it. ie - At the end of March, I copy March's sheet and rename it April, and
so on. So by the end of the year, I have 12 sheets. The first two sheets of
the year were very small and the file size was only about 1.5Mb. However,
all of a sudden, it's up to 9.5Mb. The last sheet that I copied added about
4Mb. I have no hidden sheets, have deleted all extra rows and columns. I
even tried removing all the formatting and it didn't change the file size at
all. When I Copy/Paste Special/Text Only into a new sheet, the file size
goes back to being very small. Any ideas why the file size keeps
skyrocketing?