copy formulas

[philthedil]

I have a excel worksheet that i want to copy the data and the formula
to a new worksheet .The worksheet was linked not embeded so it won
work without the link.
When i try to copy it i only get the data not the formulsa .
Any help would be a great help

 

[Peo Sjoblom]

Replace all equal signs with r=, copy what you want, then reverse the
replace, i.e.

edit>replace>find what =, replace with r=

copy and paste

edit>replace>find what r=, replace with =



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

Try:
Edit|Paste Special...|Formula

Hope this helps.