Hummm, seems like it should update when data in the other workbook is
updated. Did you hit F9? Tools Options Calculation Automatic. Does
that help?

Regards,
Ryan---

--
RyGuy


" wrote:

This is the formula i have..
=IF(COUNTIF('[RP_FEB_2008.xls]FEB 08'!$C:$C,D10)=1,"X","")
Which is a dublicate formula, but it looks in a different workbook.
It worked fine when initially set up, but doesnt seem to update when
its saved.
How can i get this to update when a new duplicate is potentially
added?
Thanks in advance.