I find if I go up to the formula bar and copy everything except the "=" sign I can paste the formula in another book without getting the first book's name.