I have had to repeatedly set my Edit options to "enable autocomplete for cell
values, " but it appears to switch itself off again at some point. I haven't
done thorough investigation as to whether this is at logoff or shutdown.

Excel2003 on XPsp2.