I am trying to delete part of formula (which calc has added to my typed formula) an irrelevant “sheet names” as formula does not refer to another sheet!
Not always irrelevant, if it is an absolute sheet reference.
Are you using the native ODS format file to save?