I use the program "Excel Diet" every so often to reduce the size of some of my larger workbooks. Works like a charm!
However, I just changed an Excel formula to be:

=COUNT(INDIRECT("E"&RangeCntBegRow):E65536)+(RangeCntBegRow - 2 )

When I run Excel Diet now, the item "E65536" now becomes !REF#. I have another formula that uses a similar address (A65536) that does the same thing. That was a surprise. What is happening to cause that??