excel forumula copy for a whole sheet

Hi,

I am trying to copy an excel sheet with formulas for many cells into another excel sheet in another application that i logon remotely.

The problem is when i just paste it would just copy the values of the cells. When i replace the = with any other character and paste it copies the formulas but, the formula is being terminated after some length since the formulas are lengthy.

And also i am not able to replace the character “A=” or “#” back to “=” after i pasted in the new sheet.

Any suggestions?
Thanks,
krs.