if I undertand you it sounds like my formula is being pasted as text as opposed to a formula - have you checked this (make sure it starts with = and not ')?