Home > Not Working > Excel 2010 Undo Not Working

Excel 2010 Undo Not Working


When you find the macro, assign a new shortcut. somewhere along the line you have a Worksheet_Change event that is firing and trashing that "Undo"... Related links Customize the Quick Access Toolbar (Windows) Configure or turn off automatic text formatting (AutoFormat) Undo an action Press + Z until you've fixed your mistake. You are undoub...(more) Q:Protect and unprotect greyed out in Excel 2007 A:Does this issue occur with one file or is it across all the files?

I know this is an old thread but I have been searching all morning and it was the ONLY ONE that came close to describing my problem (ie. In fact, it made it worse. But whenever the Macros are getting Run, all Undo-History gets cleared and nothing remain to Undo. Ask Your Own Question Stop Undo Stack From Clearing - Excel Excel Forum As you may already know, MS Excel clears the undo stack upon running a macro or executing code.

Excel 2010 Undo Not Working

Is there any workaround to this? It's the shortcut for Undo; it cancels previous actions. The fix is identical for all version of XL 2000+ (only thing that changes is the registry entry, obviously). Click Customize Ribbon.

  1. Coworker throwing cigarettes out of a car, I criticized it and now HR is involved Is there any point in ultra-high ISO for DSLR [not film]?
  2. You can't undo some actions, such as clicking commands on the File tab or saving a file.
  3. Although you can undo your latest erroneous cell deletion, bad move, or unwise copy, you can't undo your latest imprudent save. (You know, like when you meant to choose Save As
  4. I do not know what triggers the undo to stop working.
  5. If yes, then other code runs.
  6. Now, I have no window.

ADoubleDot View Public Profile Find all posts by ADoubleDot #10 08-20-2010, 06:29 PM carryme ...:illllllli:.. Advanced: Modify the undo limit Excel and all other Office programs have a default undo/redo maximum of 100 actions. Edit that may (and quite possibly may not) help to explain the issue: In Sheet1 A1 enter 1. Can't Undo In Excel 2013 If you forget to strike when the iron is hot, so to speak -- by using the Undo feature to restore the worksheet to its previous state before you choose another

Thanks. Undo Not Working In Excel 2013 Important: Remember that some actions, such as clicking commands on the File tab or saving a file, can't be undone, and running a macro in Excel will clear the undo stack, making In Sheet1 B1 enter =Sheet2!B1 Both sheets now look the same and the undo stack has: Typing `=Sheet2!B1` in B1 Typing `=A1+1` in B1 Typing `=Sheet1!A1` in A1 Typing `1` in I am talking about Undo non-macro tasks that I did immediately before running the macro.

To check this, press ALT+F11 to bring up the VBA editor and see if there are any modules in your workbook. How To Modify The Number Of Undo Levels In Excel 2010 BTW, I need to do this for more that one cell on the same worksheet. Any suggestions? To reassign the macro that's usurped [Ctrl]+Z, do the following: Click the File tab and choose Options (under Help).

Undo Not Working In Excel 2013

So the code is stuck where it cannot get out unless the user responds "Yes". Running Excel 2010. Excel 2010 Undo Not Working share|improve this answer edited Jun 19 '13 at 1:08 answered Jun 17 '13 at 14:32 pnuts 4,94431836 I fear you may be right. –supercheetah Jun 17 '13 at 20:59 Undo Not Working In Word 2013 Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

I was clutching at straws as every other option was the same, but I noticed that I had the Google Desktop Office Addin enabled on mine. this contact form will save this info! Note: For more information about the Quick Access Toolbar, see Customize the Quick Access Toolbar. does anyone have any idea how i might go about it? Undo Not Working In Word 2010

In the Commands list, choose EditUndo. If you can't undo an action, the Undo command changes to Can't Undo. Try that and the values in Sheet2 will change. have a peek here More advanced options are available in desktop versions of Office.

carryme View Public Profile Find all posts by carryme Page 1 of 2 1 2 > « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Microsoft Word Undo Button Disabled They are activated while I am editing a cell but as soon as I press enter they dim and become inactive and I cannot UNDO the last or any action!!! If worksheet has not been saved, a form shows up asking if user wants to save.

I went through every option and eventually got to the Addins.

The time now is 11:37 AM. Ask Your Own Question Excel: Prevent "undo-history" After Macros / Vba Code Run - Excel Excel Forum Dear All Please help me to get out of the following Issue; I' have Any help on this will be appreciated Thanks MG Ask Your Own Question Undo Current Sheet - Excel Excel Forum Hi again. Excel 2013 Undo Greyed Out Similar Topics | Similar Excel Tutorials | Helpful Excel Macros Why Cant I Undo After Saving In Excel? - Excel View Answers I'm using Excel 2000 and after I hit the

If you want to repeat the last action, you need to add the Repeat command to the Quick Access Toolbar first. Help needed! Remember Me? Thanks for the report.

ie: If there are already some items in the Undo list, I'd like my undo procedure added to the list rather than it replacing whatever's there. Let me know if I can explain this any better. In Sheet2 B1 enter =A1+1.