Do the number of rows and/or columns change?

If they do, there may be an issue with formulae trying to recalculate
where no results would show (results would be either "0", " " (space)
or null).

The idea of copying the spreadsheet to another might be a fix if all
you copied were the formulae and data.
Do not copy the entire spreadsheet, only the areas that have data.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=547889