Results 1 to 5 of 5

Thread: copy and paste

  1. #1
    New Lounger
    Join Date
    Apr 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question copy and paste

    On my Excel (7) I suddenly lost the ability to copy and then paste a formula in another place on the spreadsheet. I can copy numbers and words but not a formula. Help!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Are there macros running? Is it on all workbooks or just this one workbook? Can you do it on other worksheets in the workbook or other cells within that worksheet?

    Steve

  3. #3
    New Lounger
    Join Date
    Apr 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I just discovered it can copy and paste everything by the formula. I was able to copy them before. No macros running. everything else works.

  4. #4
    New Lounger
    Join Date
    Apr 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    its the formula

    It appears to be the formula that is blocking any copy and paste. I tried to copy/paste other formulas and they copy and pasted every well. Oddly, I've used that formula for many years for financial tabulations and never had a problem. Time to create a new formula I guess.
    Thanks for all your replies.
    Stan

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Is there protection on the worksheet?

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •