25/09/2013
I.T Solutions
Increase undo capacity in Excel
if u wont to increase your undo limit in excel, and u dont know how to do it... dont vary
i'm going to tell you that how can u do it..
1= Close any programs that are running.
2= Click Start, click Run, type regedit in the Open box, and then click OK.
3= In Registry Editor, expand one of the following registry subkeys,
as appropriate for the version of Excel that you are running:
Microsoft Office Excel 2007
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Options
Microsoft Office Excel 2003
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options
Microsoft Excel 2002
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Options
Microsoft Excel 2000
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Ex cel\Options
4= On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.
5= On the Edit menu, click Modify.
In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.
you don it
i'm waiting your comments....
Regards
PCVISION IT SOLUTIONS
