redo function loss after auto-save (just installed) activates.
 

This is the third time I have tried to post this, but for some reason it
never shows up in the forum, so if this is a repeat of something already seen
I apologize.

I am running excel 2000. Today I installed the auto-save function and set
it for every 10 minutes with the prompt before saving check box checked.
After installation, I began working on one of my spreadsheets and both my
undo and redo functions worked until the prompt popped up. Since I know I
lose these functions when the file is saved, I clicked on cancel in the
prompt box. At that point my redo function became disabled, even though my
undo function still worked (the stack was gone, but I could undo any new
keystrokes, just can't redo anything new). The only way I found to get my
redo function back was to close and reopen my spreadsheet.

Can anyone tell me how to keep my redo function, other than turning off the
auto-save, which would defeat the purpose of having the auto-save.

Thanks.