[good formula, I'll remember that one]
1. In your new (copied to) workbook, go in and check your entire CF'd range for broken references.
2. If thats not it, ...has your new workbook any pre-existing formatting you don't know about. If so, you may need (and try) to delete all the blank columns to the right, (or all the blank rows...all the way to 65,536!).
This sometimes works when trying to fix a mysterious CF problem.
3. Note: make sure you've checked for any slight variations in the CF or the value it is written to respond to. (Even the most meticulous person -- that would be me...lol -- can miss a minor flaw occasionally.)
Thanks,
Rob