When I highlight a cell in Excel 97 I can copy the contents as many times as I want to another cell(using crtl V) but if type something in another cell somewhere the clipboard empties itself.

This didn't use to happen with older versions of Excel or with the spreadsheet in Works (win 3.11)

I find this really annoying because with all other apps the data remains in the clipboard.

Is there some option somewhere to retain the clipboard data?