Copying formulas from Excel 2003 to Excel 2007

[raheelr]

Hello,

I am trying to copy a cell from a spreadsheet created in Excel 2003
and opened in Excel 2007. After copying that cell I am trying to paste
the formula into a new Excel 2007 spreadsheet but I do not get the
option to Paste Special Formula, it only pastes the value. Any input
into what I may be doing wrong would be very helpful.

Thanks in advance.

 

[Peo Sjoblom]

What do you mean by "do not get the option"?
Are you saying that when you select paste special there is no formula option
or do you mean you don't know how to paste special in 2007?

If the latter it's in the home tab to the left, you can also right click in
the cell where you want to paste it

 

[Bernard Liengme]

Try this:
In source file, select cell with formula to copy;
Use mouse to highlight all of the formula in the Formula Bar and use CTRL+C
to copy
VERY IMPORTANT: now press ESCAPE
In target file: select cell for formula, and in Formula Bar use CTRL+V to
paste
best wishes

 

[Dave Peterson]

Make sure you open the workbooks in the same instance of xl2007.

Open the first anyway you want, but then use the office button to open the
second (equivalent of File|Open in xl2003).

 

[Guest]

Try to paste as Hyperlink.

Regards,

Tim