Counta formula is asking for update values

[eeloveland]

I am trying to use this formula =IF(COUNTA(BMWANP!$B3:$J3)<>0,"X","") to count if any data is in a separate tab (this example uses "BMWANP" for the tab name) and if it is to mark an "X" in that cell otherwise leave it blank. I copied and pasted this formula and a window pops up that says UPDATE VALUES: INSERTTABNAME then it looks in an Offfice 14 folder...if I ignore this and close it out, "FALSE" populates in the cell.

Any ideas?
Thanks in advance for the help.