Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off undo
Hi,
Is there a way to temporarily turn off the undo function. I'm sorting 40000 rows of data and then deleting based on criteria and then resorting. I'm sure its taking forever because it wants to remember stuff so I can undo but I'd rather get on with it! Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off undo
Chriswilko -
I don't know about turning Undo off, but if you save after every big step, that clears the Undo log. -- Daryl S "chriswilko" wrote: Hi, Is there a way to temporarily turn off the undo function. I'm sorting 40000 rows of data and then deleting based on criteria and then resorting. I'm sure its taking forever because it wants to remember stuff so I can undo but I'd rather get on with it! Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off undo
I'd try turning calculation to manual first.
But maybe you can use these links: 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 And change the undo level to 0. chriswilko wrote: Hi, Is there a way to temporarily turn off the undo function. I'm sorting 40000 rows of data and then deleting based on criteria and then resorting. I'm sure its taking forever because it wants to remember stuff so I can undo but I'd rather get on with it! Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turn off undo
ps.
If you have google desktop search (or any of those other programs that index your files for quicker searching), you may want to disable it to see if that helps. Dave Peterson wrote: I'd try turning calculation to manual first. But maybe you can use these links: 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 And change the undo level to 0. chriswilko wrote: Hi, Is there a way to temporarily turn off the undo function. I'm sorting 40000 rows of data and then deleting based on criteria and then resorting. I'm sure its taking forever because it wants to remember stuff so I can undo but I'd rather get on with it! Thanks -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I TURN MY UNDO REDO FUNCTIONS BACK ON IN MICROSOFT EXCEL | Excel Worksheet Functions | |||
In Excel, UNDO/REDO is grayed out. How can I turn it back on? | Excel Discussion (Misc queries) | |||
UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
How do you turn off the Undo feature in excel? | Excel Discussion (Misc queries) | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions |