When I copy/paste a formula from an old 97-2003 file (example: cell C1 reads
=A1+B1) to a new 2007 file, it's converted from a formula to a number. I
don't want to have to recreate all the formulas in the new 2007 file.
Here's what I've tried with no success:
- choose Paste Special (it treats it as if it were an object instead of a
formula)
- save the 97-2003 file as a 2007 version, then copy/paste into a new 2007
file
- save the new 2007 file down to a 97-2003 version, then copy/paste into the
97-2003 version
- save both files as the same versions, then copy/paste

The only thing that does work is to open the 97-2003 file and save it as a
2007 version - it leaves the formulas and allows me to change the data.
However, I have current files filled with data that I simply need to
copy/paste the formulas from that old file.

Please share your wisdom, oh great ones... thanks!