lesser-equity

Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications

Register


Default Excel undo key fades out

Have a user in budget department that is using MS ofc 2003 with SP3 and the undo function fades after a few seconds of the spreadsheet being opened. This is one function that she needs to effectively do her work. Have no idea what is causing the problem or how ...


Reply
 
Thread Tools
  #1  
Old 31st Mar 2008, 11:17
New Member Group
 
Posts: 4
Default Excel undo key fades out

Have a user in budget department that is using MS ofc 2003 with SP3 and the undo function fades after a few seconds of the spreadsheet being opened. This is one function that she needs to effectively do her work. Have no idea what is causing the problem or how to resolve it.
  #2  
Old 31st Mar 2008, 13:38
Donor Group
 
Skill Level: Beginner
Posts: 722
Default Excel undo key fades out

Does "ofc" mean "Office"? Is the undo function a command button which becomes grayed out and won't click?

http://support.microsoft.com/?kbid=211922

By default, Excel allocates RAM for 16 undo levels. The registry setting that is described in this article lets you change the default value to a value that you specify. If the undo history is set to zero, no memory is allocated for undoing actions. The higher the undo history value, the more memory Excel allocates for the history. This directly affects the performance of your computer when you run Excel.

Note When you run a Visual Basic for Applications macro, Excel allocates no memory for undoing actions. This feature is disabled for optimization of performance when you run a macro.
__________________

My System: Tim

Processor(s):
Athlon 64 3500+
Motherboard:
Asus A8N-VM CSM
RAM Memory:
Corsair PC3200 CL2 DDR-400 2GB
Graphics Card(s):
nVidia Geforce 6600 512MB
Sound Card:
Cherry RS 6000 M keyboard
Hard Drive(s):
Barracuda.7+ 2x200GB 58MB/s sustain
Optical Drive(s):
Samsung DVD-ROM TS-H352
Case / PSU:
Thermaltake Soprano
Cooling:
Stock
Network / Internet:
Telewest 2x20Mb/sec
Monitor(s):
SXGA flat panel
Operating System(s):
Slackware (2.6.27.7) (Fluxbox)
  #3  
Old 1st Apr 2008, 08:45
New Member Group
 
Posts: 4
Default Excel undo key fades out

Did the change to the registry and used a value of 50 for the undohistory. After about 10 minutes the key grays out and she is not able to use it anymore.
  #4  
Old 2nd Apr 2008, 11:14
New Member Group
 
Posts: 4
Default Excel undo key fades out

User changed her auto save timer to 2 minutes and the undo function faded out when the save started. She has since turned off the auto save and the undo function has not faded out. Do not know what the connection between the 2 is. My manager thinks that it may be an update from MS that caused the problem.
  #5  
Old 2nd Apr 2008, 11:51
Donor Group
 
Skill Level: Beginner
Posts: 722
Default Excel undo key fades out

Ah. That was changed in Office 2007, the previous Excel versions clear the undo stack on any save, manual or automatic. I had no idea it blanked the undo icon as well though.

You're using an earlier version?
  #6  
Old 8th Apr 2008, 10:07
New Member Group
 
Posts: 4
Default Excel undo key fades out

Yes we are using Office 2003 with sp3. In about 3 weeks we will have new systems with Office 2007 installed being deployed to all of our personel. thanks for the info. Had a reply from individual on IT Toolbox that stated that one of the Microsoft Updates is what caused the problem. He did not state which one, but that is a mute point.
Reply

Donate

Register

Bookmarks

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Excel formula please robbie73 Office Suites & Applications 2 10th Sep 2008 11:00
Excel Question prawleprovi Office Suites & Applications 3 6th May 2008 09:52
Excel question HistoryGirl Office Suites & Applications 1 8th Apr 2008 08:09
Problem with excel antbann Office Suites & Applications 1 21st Mar 2008 05:04
Excel help Dj Ram Office Suites & Applications 2 19th Feb 2008 11:22
Thread Tools




Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Latvian Lithuanian Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish Ukrainian

Copyright ©2006 - 2009 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2009 Jelsoft Enterprises Ltd. SEO by vBSEO ©2009, Crawlability, Inc.