Formula not updating to new content.

[noalenpell]

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.

 

[ryguy7272]

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---

 

[NPell]

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

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.- Hide quoted text -

- Show quoted text -

I found out my own problem, it was...
=IF(COUNTIF('[RP_FEB_2008.xls]FEB 08'!$D$2:$D$2000,D10)>=1,"X","")
The formula wasnt supporting D.. so i set to the range from D2 to
D2000, thanks for you looking at this though.