Can't copy Formulas from one workbook to another

[rdy4trvl]

There must be a simple solution here....
I have two workbooks (separate excel files, not worksheets) but I can't copy the formula from one to another - after pasting, the result is just the values (from the copied book), no formulas.

I'm using the Ctrl + C and Ctrl + P. Even if I try dragging and dropping - I get just the values.

I must be missing something very simple.
Thanks

 

[SpillerBD]

I have always copied the formula text from the formula bar rather than trying to copy the cell when doing this process.

 

[Bluto152]

I have always copied the formula text from the formula bar rather than trying to copy the cell when doing this process.

I needed to copy a whole block of formulas, so that wasn't an option. Agreed though.

 

[dawnmau]

Do you have the two workbooks open in separate instances of Excel? To paste formulas, you need both workbooks open in the same instance.

Thank you! I saved and closed the "pasted" file, Went to the "From" file, File > Open > selected my "pasted" file. Once opened, I then copied and pasted the columns and VOILA!!! The formulas showed up and not the "values pasted" result! Thank you Richard!