+ Reply to Thread
Results 1 to 4 of 4

Undo Function Sometimes Doesn't Work

  1. #1
    Registered User
    Join Date
    08-26-2014
    Location
    Washington, DC
    MS-Off Ver
    2010
    Posts
    31

    Undo Function Sometimes Doesn't Work

    Sometimes the undo function doesn't work in Excel 2010, and I'm not sure why. For example, I will accidentally overwrite a row, and the undo button is non-functioning. The only way to get the data back is to close the document, not save, and hope for the best when I open it back up.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Undo Function Sometimes Doesn't Work

    Do you remember what you were doing just before this problem occurred?

    If you opened the file from Windows Explorer and the Preview Window is open for that file, it could interfere with many of the Excel tabs and buttons including the undo. I have experienced this quite a few times with Excel 2010. Closing the Preview Window returns Excel to normal operation without having to close Excel or the file that is open.

    Actions accomplished by Macros cannot be undone with undo as far as I have experienced.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    08-26-2014
    Location
    Washington, DC
    MS-Off Ver
    2010
    Posts
    31

    Re: Undo Function Sometimes Doesn't Work

    I don't use preview. However, I do have a macro action for every spreadsheet edit. Could this be causing the problem?
    Please Login or Register  to view this content.

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

    Re: Undo Function Sometimes Doesn't Work

    Once code modifies the Excel environment (and changing a cell is one of many ways), the undo buffer is flushed.
    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)

Similar Threads

  1. UNDO doesn't work
    By Brian Matlack in forum Excel General
    Replies: 3
    Last Post: 08-12-2010, 01:48 AM
  2. Undo function to undo Visual Basic commands
    By pierre08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2010, 04:59 AM
  3. Custom VBA function doesn't work
    By MCCCLXXXV in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2008, 04:54 PM
  4. [SOLVED] Undo doesn't work!
    By Nimish in forum Excel General
    Replies: 4
    Last Post: 08-18-2006, 11:45 AM
  5. [SOLVED] NZ function doesn't work!
    By salut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2006, 03:50 PM

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