Home > In Excel > Undo Function In Excel Not Working

Undo Function In Excel Not Working


I took a stroll through the internet looking for the answer, but the issues that I found seemed to point to the application losing its ability, which was resolved with a Page generated in 0.40204 seconds with 7 queries Register Help Forgotten Your Password? But if im just typing in a cell, press enter, what VBA code is running, or does it run everytime i press enter. When you find the macro, assign a new shortcut. http://techese.net/in-excel/undo-function-not-working-in-excel-2010.html

I would guess that the macro runs automatically fairly frequently in the background, which would cause what you're seeing. Are you saying that you have this problem and the prior solution didn't fix it? I am in the process of duplicating the workbook and removing the Macro. Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like this thread?

Undo Not Working In Excel 2013

I didn't even look at the date before replying. Are your Ink Cartridges low? Please find the Undo icon  in the quick access toolbar. Last edited by ragulduy; 07-15-2013 at 09:57 AM.

press enter on a cell or force calculate CTRL ALT F9. Posts 4,418 Re: Why do some Excel documents NOT allow me to Undo/Redo when using THIS Macro? If you want to later revert to this version, simply close the workbook without saving and then reload it from disk. Undo Not Working In Word 2010 Your cache administrator is webmaster.

No kidding. Microsoft Word Undo Button Disabled You can use Office 2007/2010/2013/2016 immediately without any training. User Name Remember Me? Classic Menu for Office 2007 It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.

Share Share this post on Digg Del.icio.us Technorati Twitter HTH, Peter Please test any code on a copy of your workbook. Can't Undo In Excel 2013 Select New Value #1, type UndoHistory, and then press ENTER. Full Bio Contact See all of Susan's content Google+ × Full Bio Susan Sales Harkins is an IT consultant, specializing in desktop solutions. my undo button was always grayed out.

Microsoft Word Undo Button Disabled

For instance, the following macro command could be the last one in your primary macro: Application.OnUndo "Primary Macro", "UndoPrimary" After this command, when the user looks at the Undo list, he This info can then be used, but the user, to "undo" macro that you created. Undo Not Working In Excel 2013 If you can't undo an action, the Undo command is dimmed. . Undo Not Working In Word 2013 Excel stores an undo history for the number of actions that you specified in step 7.

Help with populating cells in Excel.? check my blog When your primary macro is through running, there will only be a single option available on the Undo list: Primary Macro. Problem SOLVED! I would expect the operations of the Macro to be separate from the history of the document's actions. How To Modify The Number Of Undo Levels In Excel 2010

I think to get this to work without a macro you would need a way of returning whatever the selected cell is, you can use something like: =CELL("row") which sort of Entering data will still cause the undo stack to be cleared. Now, I have no window. http://techese.net/in-excel/undo-in-excel-not-working.html All rights reserved.

This tip (2060) applies to Microsoft Excel 97, 2000, 2002, and 2003. Undo Button Greyed Out In Word 2010 Join Date: Feb 2005 Posts: 1,953 That would be my guess, that a Macro (triggered by the update event) is being run. __________________ ...:illlllllli:... Password Register Blogs Wiki FAQ Calendar Today's Posts Search FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions 2015 ACTUARIAL SALARY SURVEYS Contact DW Simpson for State Specific

I just tried this.

If there is no such a mark, it means you need to add it into your quick access toolbar. Originally Posted by Sandcastle I am in the process of duplicating the workbook and removing the Macro. I then discovered if I click on the REDO button and carefully highlighted each line, it gave the option of 'undo one action' or undo 'tow (last) actions etc. Excel 2013 Undo Greyed Out This site is for you!

As you are working in Excel, there is a bit of a "safety net" in place in regards to changes you make. If this doesn't work check out the technote in the source. Repeat an action To repeat something simple, such as a paste operation, press Ctrl+Y or F4 (If F4 doesn't seem to work, press the F-Lock key, then F4). have a peek at these guys A:The rule for freezing rows and columns is...........

Share Share this post on Digg Del.icio.us Technorati Twitter HTH, Peter Please test any code on a copy of your workbook. What this Macro is doing is highlighting the current line, so your description explains what's going on. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. In Excel 2010 whenever I click outside the cell being edited the "undo" button grays-out and I loose all ability to undo any previous changes.

Right click the sheet tab and select View Code. OK, just removed the Macro and BLAM: Undo works again. You could then replace your conditional formatting with: =if(Cell("row")=row(A1),True,False) but again, you would need to actually recalculate - it won't change with selection.