+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 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 Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    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 Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    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
    64

    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 Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    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
    64

    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
    64

    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
    64

    Re: Excel will not copy formulas

    Damn Computers! good job

  14. #14
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    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.

+ Reply to Thread
Page 1 of 2 1 2 LastLast

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