+ Reply to Thread
Results 1 to 25 of 25

Excel will not copy formulas

  1. #1
    Registered User
    Join Date
    07-07-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Excel will not copy formulas

    I am trying to do a very simple copy and paste of a simple formula in Excel 2007 and nothing seems to be working. Excel will not let me copy and paste a formula and will only paste the value into to workbook. For instance, if I make a very simple spreadsheet such as:
    A1 type in 10, A2 type in =A1 (calculated A2 to be 10)
    B1 type in 5

    And then click the copy on B1, and then click paste special on cell B2, the only options it gives me are text and unicode text and so no matter how I paste, cell b2 will always be populated with a value of 5. I cannot imagine a simpler copy and paste and no matter what I do I can't make this work.
    All cells are formatted as general. It seems that all copy and pasting of formulas in my excel has been disabled. If I open any spreadsheet on my computer, I can't copy and paste formulas, but do the exact same thing on the exact same spreadsheet on any other computer and it works no problem.

    Any help?
    Last edited by jakethesnake; 07-07-2009 at 12:48 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Excel will not copy formulas

    Sounds to me as though you have 2 separate instances of XL running as opposed to 2 files within the same instance of XL.

    For ex. close everything completely, open XL, press CTRL + N to create a 2nd file in the same instance of XL, repeat your process above and you should find you can copy / paste etc... If you open 2 instances of XL and run one file in each you will experience the issues you mention.

  3. #3
    Registered User
    Join Date
    07-07-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel will not copy formulas

    I only have one spreadsheet open and one instance of excel open. I am literally trying to copy and paste from the cell above to the cell below. Not into different work books or different files.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Excel will not copy formulas

    Could you attach the offending file to the board - we can then see if it's a client issue or specific to the workbook... there may be a setting I'm not aware of
    (I suspect there are plenty!)

  5. #5
    Registered User
    Join Date
    09-16-2008
    Location
    Canada
    MS-Off Ver
    Excel 2003 (silly work wont upgrade)
    Posts
    71

    Re: Excel will not copy formulas

    sorry to add my 2 cents but did you try dragging the formula down cells? or is that not what you are looking for?

    cheers

  6. #6
    Registered User
    Join Date
    07-07-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel will not copy formulas

    I'm not at the offending computer at the moment, but it does it for all spreadsheets, even new ones, but if I save it to our common drive and open it up on any other computer, it works like a charm, so I doubt it would be a file issue (as it is happening to all files and only on this computer), but if you'd still like the file I can upload it in about half an hour..

  7. #7
    Registered User
    Join Date
    07-07-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel will not copy formulas

    And yes, I've tried dragging down, also to no avail (again, but only on this computer...)

  8. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Excel will not copy formulas

    Just checking ... not to sound like the IT dept but have you tried completely rebooting the client in question ?

  9. #9
    Registered User
    Join Date
    09-16-2008
    Location
    Canada
    MS-Off Ver
    Excel 2003 (silly work wont upgrade)
    Posts
    71

    Re: Excel will not copy formulas

    when you click on paste special check values and see if that works?

  10. #10
    Registered User
    Join Date
    07-07-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel will not copy formulas

    I haven't tried the 'magic windows fix-all' of rebooting yet, but I will now!

    And mikey, when I click paste special, the only two options are text and unicode text. Values, formulas, etc don't even appear.

  11. #11
    Registered User
    Join Date
    09-16-2008
    Location
    Canada
    MS-Off Ver
    Excel 2003 (silly work wont upgrade)
    Posts
    71

    Re: Excel will not copy formulas

    ahhhh maybe it has something to do with excel itself. I wonder if all the components are installed on it. Does it do it no matter how many different excel sheets you open?

  12. #12
    Registered User
    Join Date
    07-07-2009
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Excel will not copy formulas

    Well, well, resetting did it. By the looks of it there was a program that was accessing the clipboard that had hijacked it and was causing it to fail. It's amazing how much can be fixed by a hard reset. Thanks for your help everyone!

  13. #13
    Registered User
    Join Date
    09-16-2008
    Location
    Canada
    MS-Off Ver
    Excel 2003 (silly work wont upgrade)
    Posts
    71

    Re: Excel will not copy formulas

    Damn Computers! good job

  14. #14
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Excel will not copy formulas

    re: clipboard etc... some useful links to apps to aid determining underlying cause: http://www.howtofixcomputers.com/bb/ftopic140408.html

  15. #15
    Registered User
    Join Date
    03-17-2011
    Location
    hong kong
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Excel will not copy formulas

    In case it helps anyone -
    I had this exact problem in Excel 2003. Using this thread as a guide I traced the problem to a clipboard enhancement tool I use called Arsclip. Kill that and the copy / paste / paste special works as normal..

    It's a real shame because I find Arsclip really useful - and this is the only time I've found it to interfere with any other program.

  16. #16
    Registered User
    Join Date
    09-08-2011
    Location
    San Francisco
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unicode (hex) symbol through VBA

    Hello all, I am looking to use VBA to replace <= with character code: 2264 from Unicode (hex) or 32 from ASCII (decimal).

    Typically I would do:

    Cells.Replace What:="<=", Replacement:="=", LookAt:=xlPart, SearchOrder _
    :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False


    But as you can see from the latter half the symbol is not there. Would definitely appreciate any help that you can give me. Thank you!

  17. #17
    Registered User
    Join Date
    03-27-2012
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel will not copy formulas

    I had this exact same problem with Excel 2007 on Windows 7, and was able to solve it easily once I figured out what the problem was.

    My problem was Skype.

    Specifically, the Skype "click-and-dial" software, which installs itself in numerous programs and browsers. I de-installed Skype (including click-and-dial) then reinstalled Skype without click and dial (for some reason, it did not even offer to install it during the reinstall).

    Voila! Problem solved!
    Last edited by lextran12; 03-27-2012 at 11:11 AM.

  18. #18
    Registered User
    Join Date
    04-25-2012
    Location
    CT, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel will not copy formulas

    I have been having the exact same problems - I just deleted the Skype "click-and-dial" software. Seems to have cured the problem but it was an on or off issue so I am going to give it a few days.

  19. #19
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,825

    Re: Excel will not copy formulas

    It usually only causes a problem if you have the browser add-in installed and have your browser open while Excel is open. If the browser is closed, copy/paste should work normally. There is also an updated version of the browser add-in from Skype if you do need it installed.

  20. #20
    Registered User
    Join Date
    05-15-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel will not copy formulas

    Try this: Click on: Formulas > Calculation Options. From the drop down mwnu, choose Automatic.
    Let me know if that works.

  21. #21
    Registered User
    Join Date
    06-08-2012
    Location
    Vietnam
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Excel will not copy formulas

    it is right, i also experience the same error, can not "copy" or use "paste special option" though i have been trying a lot of steps
    to this problem you can:
    1/ Close Skype if it is opening
    or
    2/Delete/ remove Skype from Google Chrome browser, no need to unistall it

    Done. Every thing is ok now.

  22. #22
    Registered User
    Join Date
    06-08-2012
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel will not copy formulas

    I'm having the same problem. When you say you reset it, do you mean you just re-booted your computer?

  23. #23
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,825

    Re: Excel will not copy formulas

    Uninstall the Skype browser add-in and you should be able to copy and paste in Excel. If you need the Skype add-in, download the latest version from their website which has fixed the compatibility issue.

  24. #24
    Registered User
    Join Date
    09-21-2012
    Location
    Wirral, Merseyside, England UK
    MS-Off Ver
    Excel 2010, Word 2010, Access 2003
    Posts
    1

    Angry Re: Excel will not copy formulas

    I have similar problems in both Excel and Word - but they are random. Sometimes they copy normally, sometimes it is text-only which is very annoying in both. However, I do have Skype running so I shall try what has been suggested here. Thanks.

  25. #25
    Registered User
    Join Date
    10-01-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Excel will not copy formulas

    Just had this happen in Excel 2010 and couldn't figure out what was happening until some googling found this discussion.

    For the record it was PushBullet's Universal Copy/Paste feature that was the culprit in my case. Hope this is helpful for someone else down the road.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1