Hi,
This usually happens when a SUMIF tyype formula is trying to reference a
closed workbook. The solution is to either open the other workbook or change
the SUMIF formulas to SUMPRODUCT.

hth

Regards,
Bony

"plantslayer" wrote:

I have a number of worksheets linked. There is some that are not linking
properly but are showing up with a #VALUE! error in the cell. I have retried
reference the appropriate cell, formatting to General and Text. Nothing has
worked. Is there a formula within this cell that needs to be cleared to be
able to reference properly?