Mark
There are several causes for a file getting bigger than one thinks it
should.
Let's start with the most common. This is that he "Used Range" in the
sheets is much larger than you think it actually is. For instance, say that
the last cell of your data on some particular sheet is actually R500. But
Excel thinks the last cell is CA35000. That will cause the file size to be
bigger than you expect.
Do this with every sheet in your file. Manually find and note the last
cell of your data. Now do Ctrl - End. This will take you to the cell that
Excel thinks is the last cell of your data. If these two "Used Ranges" are
significantly different in size, that may be your problem.
Another cause is that Excel may think that your code modules are larger
than they are. But this wouldn't cause the size growth that you are seeing.
Post back and tell us what you find with the Used Range test above. HTH
Otto
"Mark" wrote in message
...
I am currently building a workbook with multiple pages which tie data
between various tabs within the same workbook. There are a number of
interations that the data is going through; however, there are no pivot
tables, no references to other workbooks, and 2 very small macros.
However,
the file size recently jumped from 5meg to 10meg.. and then again from
10meg
to 30meg.

Any ideas on what could have caused the problem?

Currently, I am reworking some of my equations early on in the data
processing, so there are a number of #ref errors on later pages. Could
this
be why?