+ Reply to Thread
Results 1 to 10 of 10

Excel features mysteriously no longer working

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Excel features mysteriously no longer working

    I'm perplexed. Today as I was working on my workbook, I noticed that the copy function was acting quirky. Normally, I could copy with CTRL-c, and repeatedly paste with CTRL-v. Now, I can only paste once. For a while, it was also pasting values, not the formula itself.

    Now, I'm noticing that the "undo" function is no longer working.

    Has anybody seen this sort of thing before?? More importantly, has anybody got a suggestion as to how I fix it?

    Thanks!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,474

    Re: Excel features mysteriously no longer working

    Hi Gordon,

    I'd replace the batteries in my wireless keyboard. (note - this is a wild *** guess )
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Excel features mysteriously no longer working

    Further observations:
    'Undo' turns on when I'm typing information into a cell, but as soon as I hit enter to complete the entry. It turns off again.

    When I start a new spreadsheet, 'Undo' works again.

  4. #4
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Excel features mysteriously no longer working

    Quote Originally Posted by MarvinP View Post
    Hi Gordon,

    I'd replace the batteries in my wireless keyboard. (note - this is a wild *** guess )
    Good thought, but I'm running on a laptop :-)

    It's not just that CTRL-Z doesn't work, the whole undo icon (that curvy arrow to the left) greys out...

  5. #5
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Excel features mysteriously no longer working

    I had a file that did the same sort of things you are speaking of. But it was only one file and I also could no longer use the paste formula option, it would paste the same address as the original cell and when auto filling it acted like the range was locked when it was not. Unfortunately I did not find a solution and I could not live without those features so I made a whole new workbook and re-entered the data. As copying sheets and moving to the new workbook keep that funky formatting. That was on Office 2007 BTW. I upgraded to 2010 and that file worked fine, just for your info. (I had to keep the original file for tax purposes)
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,474

    Re: Excel features mysteriously no longer working

    My laptop's Enter and Space keys stopped working last week. I blew the keyboard out with canned air. I think I had dust or food or stuff stuck between the keys. I even turned it upside down and squirted air on it. It works fine now.

  7. #7
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Excel features mysteriously no longer working

    Quote Originally Posted by JapanDave View Post
    I had a file that did the same sort of things you are speaking of. But it was only one file and I also could no longer use the paste formula option, it would paste the same address as the original cell and when auto filling it acted like the range was locked when it was not. Unfortunately I did not find a solution and I could not live without those features so I made a whole new workbook and re-entered the data. As copying sheets and moving to the new workbook keep that funky formatting. That was on Office 2007 BTW. I upgraded to 2010 and that file worked fine, just for your info. (I had to keep the original file for tax purposes)
    Sigh...recently updated to Office2010 Professional, so apparently the ghost is still around...

    Do you think that copying and pasting data into an intermediate program (i.e., pasting into word as unformatted text) would work as well?
    Also, would I need to retype all the macros, or could I cut and paste? And now that I think on it, it's also full of semicomplex formulas and conditional formatting....oy...

  8. #8
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Excel features mysteriously no longer working

    OK, spent a few hours doing some more digging, and I have some more leads...

    According to http://answers.microsoft.com/en-us/o...d-e3aa5066ca57 (down in the discussion portion), there are a variety of possible causes.

    I looked at the registry option, but decided against mucking around there until I had no other choice. My workbook does, however, have a worksheet_change event on the sheet in question. I removed the entirety of the code, and I now have my undo and multiple CTRL-v pasting ability back!!!

    Curiously, though, I had called some macros within a worksheet_change event before this all happened. I added a few more into the mix today, though. Perhaps there is some sort of limit in the works?

    Anyway, I think I'll keep this thread alive and keep reporting progress as I find it...

  9. #9
    Registered User
    Join Date
    05-26-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Excel features mysteriously no longer working

    I think the problem came to light because of the complexity of the macros. On the main page (where I'm calling the macros), when a single value changes, the sheet goes through and recalculates dozens (or even hundreds) of individual values across multiple sheets, often in an iterative manner, changing one cell at a time. This (I think) owverwhlems the undo function.

    So, I now have some other questions, which means some new posts to the forum

    Thanks again!

  10. #10
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    Re: Excel features mysteriously no longer working

    Once a macro makes any change to the environment (changing a cell is most common, but most anything else as well) the undo stack gets flushed. This is not new behavior.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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