I’ve noticed that the autocomplete in Excel only completes words that are already in the spreadsheet somewhere else. Is there any way to autocomplete words not already present?
Also, is there any way to make Excel ignore the fact that I have two functions the are circularly defined? I have a function that maps a word to a number called wordtocode, and another that converts a number to a word called codetoword. I set up two cells so that the one on the left is defined as codetoword(B1) and the one on the left is wordtocode(A1). This way both cells start out empty, but if I fill in one the other is automatically completed. However, excel pops up an error message because the functions are defined in terms of each other. The sheet still works, but the error message appears any time I change something. Can I make it go away and not come back?