ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot copy formula to another worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/114466-cannot-copy-formula-another-worksheet.html)

SHIPP

Cannot copy formula to another worksheet
 
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

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


All times are GMT +1. The time now is 07:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com