I have set an addresses as “A1+B1”, “A2+B2”, etc. When I reopen the file, all the references to address default to $A$1+$B$1, etc. Is there anyway to set the default for the entire sheet/file? Or have them remain as entered?
Are you saving to the OpenDocument format (.ods)? If not, there might be conversion problems.
It only happens to one .xls file. Other file, the calculation formula remains the same. I’ll try saving it as an .ods and see if there are changes.