Zend certified PHP/Magento developer

Issue in Excel 365 64-bit, in the Find/Replace dialog, the “Find what” and “Replace with” dropdowns are not remembering prior entries

Cannot find this anywhere on Google.

I recently upgraded to the 64-bit version of Excel 365. In this version of the application (not the online version), I am seeing an issue with the Find/Replace dialog.

Specifically, the “Find what” and “Replace with” dropdowns are not remembering prior entries. I don’t know precisely when this started, but I first noticed 2-3 weeks after the upgrade, and it is the only change I can think of that might be causative. I am running a macro that uses Selection.Replace for some of the more repeatable replacements, but the workbook I’m working on also has some ranges where it isn’t safe to do this in bulk, and removing the macro doesn’t seem to have any effect.

Anyone seen this before, and more importantly, figured out how to fix?