Thread: Formula not updating to new content.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] noalenpell@gmail.com is offline
external usenet poster
  
Posts: 4
Default Formula not updating to new content.
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.
Reply With QuoteReply With Quote