I don't know that many of us have the internal knowledge of Excel to fully
explain this file size growth. However it is true that cell comments are
very expensive in terms of memory and disk space. In a one worksheet
workbook with nothing but a brief comment in the range A1:Y650 it saved as
almost 5 megabytes in Excel 2003. I _think_ the reason the file grows so
most more than the size of the text in all the comments is that each comment
is a graphic object.

--
Jim
"ICE" wrote in message
...
| After inserting comments the file size has grown from 1.5 meg to over 45
meg.
| There are approximately 7 worksheets.
| Each Worksheet data range is about from 25 columns wide and 650 rows long.
| Not all cells have a comment, but most of that range does.
| That means that each worksheet contains less than 16,250 comments with
data.
| The entire workbook contains less than 113,750 comments with data.
| Is there any reason why the file size of this document grows
substantially?
|