Select and copy the formula in the formula bar. Be sure to hit <Escape
after copying so you don't actually change the formula in the original cell.

"Mac" wrote:

I'm trying to copy a formula from 1 spreadsheet to another. The formula
always changes to show the filename of the previous spreadsheet.

How do I copy/paste a formula "as is" without the filename being attached?