What's the formula look like? Sumif and Countif will act like that.

Biff

"WesJFrank" wrote in message
...
What does it signify when a spreadsheet will not update from its links
unless
both spreadsheets involved are open under Excel? Sometimes this happens,
sometimes it doesn't. I cannot tell the divergence between the two
situations. "value" is the usual error message in each cell with a link.