View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Cannot copy formula to another worksheet

Do you have any event macros running?

Sometimes macros can kill the clipboard. If you have a worksheet_activate event
firing (or some other event), it could cause this problem.

If you open your workbook with macros disabled, does the problem go away?

SHIPP wrote:

I am using Excel 2003. I am unable to copy a cell with a formula from one
worksheet to another. What is the problem? As soon as I copy it and move to
another spreadsheet both the paste icon and the paste word are greyed out.
--
M. Shipp


--

Dave Peterson