Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I reactivate my undo and redo functions in Excel?

These 2 functions no longer work. I did not do anything special from 1 day
to the other and suddenly I could no longer undo or redo. I have uninstalled
and reinstalled Excel 2000, but this did not solve the problem. I can only
think that I installed an MS fix that would have caused this. Any idea
anyone?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I reactivate my undo and redo functions in Excel?

You could be using a workbook that has event macros. Most macros that do
anything destroy the undo/redo stack.

I'd start excel in safe mode:
close excel
Windows start button|Run
type:
excel /safe
and do a few things to see if undo/redo work.

If they work ok, then you'll have to find the workbook that contains the macro
that's doing the damage.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

=======
Another thing that could have gone wrong is that a registry entry was tweaked.

There's a setting in the windows registry that tells excel how many undo levels
to keep track of--maybe it was set to 0.

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944

Andliz wrote:

These 2 functions no longer work. I did not do anything special from 1 day
to the other and suddenly I could no longer undo or redo. I have uninstalled
and reinstalled Excel 2000, but this did not solve the problem. I can only
think that I installed an MS fix that would have caused this. Any idea
anyone?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Undo, Redo Excel 2003 zvg Excel Discussion (Misc queries) 1 October 1st 08 04:33 PM
In Excel, UNDO/REDO is grayed out. How can I turn it back on? DeerMusic Excel Discussion (Misc queries) 5 April 13th 08 11:54 AM
undo and redo do not work CidsUprite Excel Worksheet Functions 4 May 11th 07 03:15 AM
Excel should undo/redo after saving a file--just like Word. [email protected] Excel Discussion (Misc queries) 3 May 26th 05 12:11 AM
undo/redo action dmuraki Excel Discussion (Misc queries) 3 November 30th 04 12:11 AM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"