Could you describe more detailed for “change A1 per "Goodbye". do NOT save”? Does it mean you change the A1 but not save the file? If it is yes, I can reproduce the scenario but I can select the “live” data.
If you change A1 from “world” to “goodbye”, and press “Enter”, you can select the latest data, but if you didn’t press “Enter”, you will always select “world” from the sheet.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.